What do you mean "chunked"? I figured it would be easier to track about 32,000 images in MySQL than in files, so I setup a test to see what the performance difference is and if storing in MySQL would actually work.
Everything is working and it's a lot easier to keep track of the images in MySQL. I ran some performance tests using Apache's ab though and there's a huge performance difference - 38 times faster grabbing the file. It could be my test system here at home. I've asked my ISP to upgrade my production server to PHP5 so that I can run tests from there. There could also be performance hits in the script that grabs the images from MySQL, because I tried using OOP. I was told OOP would be a faster approach, but I'm pretty new to it and may not have done something correctly. I'm going to create some non-OOP scripts to cross-reference the tests. I only have one production server, so I won't be able to separate / dedicate servers. Your mention of chunking sounds promising though. Actually, I'd appreciate any ideas or recommendations you have. Thanks, Ed > -----Original Message----- > From: DreamWerx [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 28, 2004 8:54 AM > To: GH > Cc: Jigal van Hemert; [EMAIL PROTECTED] > Subject: Re: Images > > Separate/dedicated servers for web/database. All the data was > chunked to allow faster streaming/lower overhead (large > images/files).. If you have more specific questions I can answer > them.. > > > > On Tue, 28 Sep 2004 11:49:27 -0400, GH <[EMAIL PROTECTED]> wrote: > > Is there anything special in your setup that you did to have such good > > performance? > > > > > > > > > > On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx <[EMAIL PROTECTED]> > wrote: > > > It's an argument that can go on forever... We have 10's of thousands > > > of images in mysql databases.. very fast/reliable.. easy to > > > replicate, stream, etc.. > > > > > > > > > > > > > > > On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert <[EMAIL PROTECTED]> > wrote: > > > > From: "GH" <[EMAIL PROTECTED]> > > > > > > > > > I was wondering how to get images into and out of a Mysql database > > > > > was told it was possible. > > > > > > > > > > I have mysql 4.0.18 > > > > > > > > The general opinion is that files should be stored in a file system > and not > > > > a database. There are circumstances that you might want to store > binary data > > > > in a database. > > > > Take a look at the BLOB column types > > > > (http://dev.mysql.com/doc/mysql/en/BLOB.html). > > > > > > > > Regards, Jigal. > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
