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).
HTH Bogdan Scott Houseman wrote: > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
