Loading images to MySQL using Read/Write

Bill Marriott wjm at wjm.org
Mon Feb 26 11:07:08 EST 2007


Stephen is right. BLOBs are slow and stress your server more than necessary.

- A lot of web hosts don't care so much about how much disk space or 
bandwidth you use, but are very unhappy when you cause high CPU load. 
Storing images within a MySQL db is a recipe for high CPU usage.

- Databases aren't optimized for image storage and retrieval. Binary files, 
especially a bunch of them, will cause the database to have bits stored in a 
very inefficient way, physically, causing: needless fetch operations; a 
completely defeated cache; poor memory usage on the server; and slowdowns in 
general.


"Stephen Barncard" wrote:
> 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.






More information about the Use-livecode mailing list