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

2002-09-19 Thread Tracker1
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 f

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

2002-09-19 Thread David Hollister
:07 AM To: Luis Ferro; [EMAIL PROTECTED] Subject: 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

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

2002-09-19 Thread Rich Gray
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