RE: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions
| From: | Jay Blanchard | Date: | Thu, 04 Dec 2003 12:36:05 +0000 |
| Subject: | RE: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-171808@lists.php.net to get a copy of this message | ||
[snip]
2) Is there any advice for or against storing images as blobs in a
database? Or is it better to store them on the web server file system?
[/snip]
Never store images as blobs, never. The read/write operation to the
database for these is expensive and unnecessary. Store a reference to
the image instead, which can be quickly and easily called.
Also, a 2Mb image file...even on an intranet this is just wrong unless
you have a need for high-res photos. If someone accessed this on a
dial-up it would cause them avery long wait indeed.