I've done some testing, on better rdbms' it can work about as well, and if you process the output, ie, you do a security check on the request, and return the file, the db can be faster since it needs to be processed anyways... but the webserver can "puke out" files faster than the db can deliver from filesystem/cache to the server/script and out.
Rich Gray wrote: > Luis > FWIW... > I would always choose storing the URL to the image in the database over > storing the binary image in a text/blob field.... > I can't back up my choice with hard evidence - just a gut feeling that an > injudicious 'select * from blobtable' would probably cripple the server > performance wise > Has anyone done any tests? I'd be interested to see the results and be > proven wrong if necessary! > Cheers > Rich > -----Original Message----- > From: Luis Ferro [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 11:55 > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] Pool: Pictures as files or text/blobs > > > From a performance wise point of view... what is preferable: > > a) placing pictures in blob/text fields in binary... > b) placing the picture name/directory in a varchar field and the picture > as a file in the refered directory... > > What would you choose and why? > > Thanx and cheers... > Luis Ferro > TelaDigital.Net > > > --- > [This E-mail scanned for viruses by Declude Virus] > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- ----------------------------------------------------------------------- Michael J. Ryan | ICQ: 4935386 tracker1(at)theroughnecks(dot)net | AIM/AOL: azTracker1 Roughneck BBS: | Yahoo: azTracker1 http://www.theroughnecks.net | MSN: (email address) telnet://theroughnecks.net | Trillian: www.trillian.cc --- Synchronet 3.10j-Win32 NewsLink 1.30 * Roughneck BBS - www.theroughnecks.net - telnet://theroughnecks.net -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
