Loading images to MySQL using Read/Write

Jim Schaubeck 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 ! :)

Jim...

 
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 
>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
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution
>
>



More information about the Use-livecode mailing list