The answer I would give at this moment would be a variant of your A)
version where the hash directories would further contain directories
limited to, say 300 images. Found it out after a painfully slow
experience with MySQL blobs. I did not however implement this solution
yet (still using the blobs due to lack of time), so I can't give you an
actual comparison (hence the format of my first sentence).
Scott Houseman wrote:
> Hi there.
> Which way would be the most efficient/fastest to access images from an image
> A) Store image files in a hash directory structure AND storing each file's
> information in a mysql table
> 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
> - 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
> Scott Houseman
> Jam Warehouse http://www.jamwarehouse.com/
> Smart Business Innovation
> +27 21 4477440 / +27 82 4918021
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php