I have also seen that if clusters on the hard drive go bad that affect the folder. All images in that folder are now inaccessible.
-B -----Original Message----- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 5:42 AM To: CF-Talk Subject: maximum number of files in directory I'm creating a database for a store. It will probably have several thousand items (but will probably never come close to 10,000). The pictures of the items will be stored in a file directory (not as a blob in a database). What is the maximum amount of files that can be stored in a directory and still have an efficient response time. Each item will have at least two graphics if not three or four #itemID#-th #itemID# It is quite possible that there could be 15-20,000 images in this directory. Is that too many? The alternative is to store the graphics according to designer /graphics/items/#designerName# / #itemID#.jpg or maybe categories (dresses, denim, jewelry) (the advantage of this would be fewer directories than designers) /graphics/items/#categories# / #itemID#.jpg It would be so much simpler to have all the graphics in one directory. Will I be causing problems later on by doing that? Gilbert Midonnet 718.928.4524 www.glmdesigns.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
