Jim,

Why do you want to store images in MySQL? I know it can be done but Blobs can be tricky and I imagine that big binaries slow down the SQL server quite a bit.

Have you considered storing *references* to the images in the database instead? Instead of a blob, you could be storing the text string like

"http://yourserver.com/images/234204.jpg";

You could store the images on a web or other server. It is far easier managing images in their native storage format. I doubt it would be faster to store images in a database, and require a loading step for each image.

You'll note that the php program Gallery uses this method. Gallery never stores image data in MySQL.


sqb



If read/write is not the way to go, any other ideas on how to store Jpegs to a MySQL field?

Thanks for your help,
Jim...

--


stephen barncard
s a n  f r a n c i s c o
- - -  - - - - - - - - -



_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to