Loading images to MySQL using Read/Write
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
"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