RE: [PHP-WIN] Pool: Pictures as files or text/blobs

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:lferro@teladigital.net] Sent: 19 September 2002 11:55 To: php-windows@lists.php.net 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