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. _______________________________________________ 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
