Re: using php and mysql with images

I'm with you Ian, I would be interested in knowing if this pertains to seconds or minutes and what is the cut off. I like to keep everything together. It just goes against my grain to insert another link to go chasing files elsewhere. If there is that much of a difference, I would go the extra mile. If there is not, I would just rather keep everything nice, neat and compact together. Sharon ----- Original Message ----- From: Ian Willis <Ian.Willis@spider.ento.csiro.au> To: 'Cosenza, Mario' <mcosenza@engsvcs.com>; <php-db@lists.php.net> Sent: Wednesday, June 28, 2000 8:31 PM Subject: RE: [PHP-DB] using php and mysql with images > Yes the performance may suffer but storing all the information in a database > make sense for a number of applications where > The data is structured and the image is part of the structure, performance > gains may be better realized by hardware and other optimisations. > The quantity of data is such that the organisational benefits of the > database more than outweighs the performance hit. > > Basically storing images external to the database is a performance kludge, > it is inelegant but useful in a number of situations. Once this fact is > accepted the whole response of images is database is bad can be seen as a > load of twaddle. An example is that I work for a research organisation that > studies insects in Australia, there are around 200000 species of insects in > australia. Each species may have have multiple blob associated with it such > as DNA sequences, images etc. Should I have in excess of 200000 image files > in a directory? > A useful answer would be to point to some figures that allow the user to > glean when storing images in a database would be appropriate, when it is a > borderline case and when it is silly. Currently I don't know these things > but I would appreciate some rough benchmarks came out that allowed users to > find an appropriate compromise between performance and data integrity. > > -- > Ian Willis > Unix Systems Administrator > Division of Entomology > CSIRO > ph 02 62464391 > > > -----Original Message----- > > From: php3@developersdesk.com [mailto:php3@developersdesk.com] > > Sent: Thursday, 29 June 2000 10:57 > > To: Cosenza, Mario; php-db@lists.php.net > > Subject: RE: [PHP-DB] using php and mysql with images > > > > > > Addressed to: "Cosenza, Mario" <mcosenza@engsvcs.com> > > php-db@lists.php.net > > > > ** Reply to note from "Cosenza, Mario" <mcosenza@engsvcs.com> > > Wed, 28 Jun 2000 12:35:38 -0400 > > > > > > > > > > > > Check out > > > http://www.phpbuilder.com/columns/florian19991014.php3. > > > This is how I learned it. > > > > > > I still don't know the performance implications of doing this. Does > > > anybody know how well MySQL handles blobs (expically lots of them?) > > > > > > > This has come up many times, and I think the consensus on the list is > > that there is little to no advantage to storing your images in the > > database. Store the images in a directory, and put the filename in the > > database. > > > > Since images are retreived by <IMG SRC="filename"> you have to provide > > a separate program to get the image out of the database and send it. > > There is no way to inline the images with the web page source when you > > send it, it is always a separate transaction. > > > > To get an image from the database you have to run a program, > > open a database connection, transfer the image from db to program, > > add the headers, and send it. It is easier and faster to let the web > > server send the image file. > > > > > > > Mario > > > > > > > > > -----Original Message----- From: Matt Dooner > > > [mailto:mdooner@mindspring.com] Sent: Wednesday, June 28, 2000 12:35 > > > PM To: php-db@lists.php.net Subject: [PHP-DB] using php and mysql > > > with images > > > > > > > > > Here's what I need to do; Take an image from a file input in an HTML > > > form and, using php, put it into a mysql blob feild. Later, > > I need to > > > take the blob and display it as an image on a web page. Is this > > > possible and if it is, could someone please tell me how to > > do this. I > > > have search though both the php and mysql docs and have found > > > nothing. > > > > > > > > > Rick Widmer > > Internet Marketing Specialists > > www.developersdesk.com > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >