Grabbing the file was 38 times faster because MySQL was not designed to be a filesystem. There are filesystems out there specifically designed to handle hundreds of thousands of small files. One of the best is ReiserFS http://www.namesys.com
If you record the filename in mysql tracking becomes a non issue. -- Eric Bergen [EMAIL PROTECTED] On Tue, 28 Sep 2004 09:19:47 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]