Bill and Stephen, I'll take your advise. I want to do the right thing. But I'm not sure how...I have a Mac mini running the MySQL now. Do I need another server to run the process for the image files? I have no problem getting one just want to know if that is best. Also, What type of server app should I use if not MySQL? FTP? etc I just learned about MySQL (seems pretty straight forward) so I can learn another program. Just need to know which one.
Pointers on reading material is very much appreciated as well...I know you guys are busy with your own projects so I appreciate the help ! :) Jim... On Monday, February 26, 2007, at 08:07AM, "Bill Marriott" <[EMAIL PROTECTED]> wrote: >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 > > _______________________________________________ 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
