List:General Discussion« Previous MessageNext Message »
From:Ed Lazor Date:September 28 2004 4:19pm
Subject:RE: Images
View as plain text  
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:dreamwerx@stripped]
> Sent: Tuesday, September 28, 2004 8:54 AM
> To: GH
> Cc: Jigal van Hemert; mysql@stripped
> 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 <garyhotko@stripped> 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 <dreamwerx@stripped>
> 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
> <jigal@stripped>
> wrote:
> > > > From: "GH" <GaryHotko@stripped>
> > > >
> > > > > 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/mysql?unsub=1
> > > >
> > > >
> > >
> >
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
ImagesGH28 Sep
  • Re: ImagesEric Bergen28 Sep
  • Re: ImagesJigal van Hemert28 Sep
    • Re: ImagesDreamWerx28 Sep
      • Re: ImagesGH28 Sep
        • Re: ImagesDreamWerx28 Sep
          • RE: ImagesEd Lazor28 Sep
RE: Imagesjabbott28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesEric Bergen28 Sep
  • RE: ImagesEd Lazor28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • RE: ImagesEd Lazor28 Sep
  • Multiple Insert Statement?Eve Atley28 Sep
    • Re: Multiple Insert Statement?GH28 Sep
      • Re: Multiple Insert Statement?SGreen28 Sep
    • Re: Multiple Insert Statement?Paul DuBois28 Sep
      • RE: Multiple Insert Statement?Eve Atley28 Sep
        • RE: Multiple Insert Statement?mos28 Sep
        • Re: Multiple Insert Statement?Rhino28 Sep
        • Re: Multiple Insert Statement?Rhino29 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • Re: ImagesGH28 Sep
    • Re: ImagesDreamWerx28 Sep
Re: ImagesDreamWerx28 Sep
Re: ImagesGH28 Sep
Re: ImagesDreamWerx28 Sep