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


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to