Image library
| From: | Scott Houseman | Date: | Wed, 21 Aug 2002 11:45:14 +0000 |
| Subject: | Image library | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-113422@lists.php.net to get a copy of this message | ||
Hi there.
Which way would be the most efficient/fastest to access images from an image
library.
A) Store image files in a hash directory structure AND storing each file's
information in a mysql table
OR
B) Storing image information in mysql table AND storing the image in a BLOB
field in that table.
The way I see it, considerations to be taken into acount:
- Is it quicker/better to retrieve image from table & then stream out to
browser OR simply direct the browser to the file?
i.e <IMG SRC="/imagelib/image.php?iImageID=10"> OR <IMG
SRC="/imagelib/5/f/10">
- Will a database OR filesystem be more scalable i.e. which wil perform
better when there are 10000 images in the libary?
Thanks in advance
Regards
-Scott
--
Scott Houseman
Jam Warehouse http://www.jamwarehouse.com/
Smart Business Innovation
+27 21 4477440 / +27 82 4918021