Storing and displaying Images

[alanfox70]

I am trying to find out which one of following two (2) options is fastest and
most reliable in order to work with 100,000 images located in 100 folders:

Option 1: ?Storing the path of the image file on a database?
For this I would have a 4 columns table with 100,000 records to store the
100,000 paths of the images. I?d have to use "CFQUERY" and "IMG" to retrieve
the images

Option 2:?Storing only the folder names where the images are located? .
For this I would have a 2 columns table with 100 records to store the 100
folder names.
I?d have to use "CFQUERY" to get the folder names and "CFDIRECTORY" and "IMG"
to retrieve the images

Which Case according to your experience is the fastest and most reliable way
to serve images.

Your feedback will be very welcome

Thanks a lot!

[jdeline]

I would imagine the first option would be faster. Your database won't break a sweat dealing with 100,000 records. Be sure to establish the appropriate index(s) to speed up your SELECT.

[alanfox70]

jdeline,

Thank for your response.

But when a database starts getting slow? at 1,000,000 records? is it matter
how many users are pulling different queries from this table?

Thanks for your help!

[PaulH]

your OS will start having troubles before the db will if you use option 1.

[alanfox70]

Paul,

so I guess you recommend option 2, right?

Let me know, thanks