Loading images to MySQL using Read/Write
schaubeck at mac.com
Mon Feb 26 12:25:43 EST 2007
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 ! :)
On Monday, February 26, 2007, at 08:07AM, "Bill Marriott" <wjm at wjm.org> 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
>"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
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode