kaihirst
08-24-2005, 10:33 AM
Hi,
Theres not much I generally dont know about MySQL, but I do ahve a bit of a problem.
I origionally designed a large frameworked Database management system for a government site that was origionally using alphanumerical text in their database.
Now they are starting to use digital formatted photographs.
The problem is that when I do load an image into MySQL (use MySQL for development of the application prior to deployment) the applicational response time significantly slows down.(25%)n in high user cases, (5.2% in others)
In addition to this the server recourses are moving above my own developed optimum level of tolerace, thereby if it does rate higher than the TTL percentage, we are looking at tolerace faults on the regional servers, to which I am not willing to accept at all under any circumstances.
Anyways, my question is without posting my way of storing images on databases (little bit complicated as I store them in unformatted compressed machine code, then let the server encode them for visual acceptance), please can all who reply to this message send me their ways of image format storage on a MYlSAM table in MySQL 4.1.1 alpha. Generally, I think that my way of storing the information is slowing the server down, and not the coding as have run debugging tests and diagnistoc recourses to evaluate. So ned your ideas and input on this oen peeps.
if you need specifics, all users for this applicaton will be on Windows XP pro, servers will be Microsoft IIS 5.0, Windows server 2000, Post deployment the database will be Oracle, but principally this wont make a difference due to the formats that oracle work on. Developmetn satage platforms will be:
hard coding on Visaul Studio 2005 Enterprise MSDN affiliate PRE Release.
Dreamwaver MX 05 for intranet deployment.
code used willbe the following.
Vbscript and Javascript for the server/client workstations
External users such as PDA/Laptops will be on .NET C#
external site will be coded using ASP.net C#, with a 16 bit DEC XML encryption.
intranet and internet systems will be on different servers, adn not series connected.
HTTPS enabled.
Generally need your ideas on the SQL image storage/reference side of things mainly, but the specifics are there if you need to referr to them.
many thanks for your time all,
Kai Hirst :thumbsup:
Theres not much I generally dont know about MySQL, but I do ahve a bit of a problem.
I origionally designed a large frameworked Database management system for a government site that was origionally using alphanumerical text in their database.
Now they are starting to use digital formatted photographs.
The problem is that when I do load an image into MySQL (use MySQL for development of the application prior to deployment) the applicational response time significantly slows down.(25%)n in high user cases, (5.2% in others)
In addition to this the server recourses are moving above my own developed optimum level of tolerace, thereby if it does rate higher than the TTL percentage, we are looking at tolerace faults on the regional servers, to which I am not willing to accept at all under any circumstances.
Anyways, my question is without posting my way of storing images on databases (little bit complicated as I store them in unformatted compressed machine code, then let the server encode them for visual acceptance), please can all who reply to this message send me their ways of image format storage on a MYlSAM table in MySQL 4.1.1 alpha. Generally, I think that my way of storing the information is slowing the server down, and not the coding as have run debugging tests and diagnistoc recourses to evaluate. So ned your ideas and input on this oen peeps.
if you need specifics, all users for this applicaton will be on Windows XP pro, servers will be Microsoft IIS 5.0, Windows server 2000, Post deployment the database will be Oracle, but principally this wont make a difference due to the formats that oracle work on. Developmetn satage platforms will be:
hard coding on Visaul Studio 2005 Enterprise MSDN affiliate PRE Release.
Dreamwaver MX 05 for intranet deployment.
code used willbe the following.
Vbscript and Javascript for the server/client workstations
External users such as PDA/Laptops will be on .NET C#
external site will be coded using ASP.net C#, with a 16 bit DEC XML encryption.
intranet and internet systems will be on different servers, adn not series connected.
HTTPS enabled.
Generally need your ideas on the SQL image storage/reference side of things mainly, but the specifics are there if you need to referr to them.
many thanks for your time all,
Kai Hirst :thumbsup: