Thanks all, I was pretty sure that 10-20,000 was way too much but not certain how best to organize it. I'm still thinking it through. Thanks about the point regarding category. (Category would not be a good choice, since someone may choose the wrong category first, then update the product.)
Since each item will have at least two accompanying photos I'll probably do something along the line you suggest but probably bring it down to 100 or 250 instead of a thousand. Thanks Gil -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 9:58 AM To: CF-Talk Subject: Re: maximum number of files in directory >>or maybe categories (dresses, denim, jewelry) (the advantage of this would be fewer directories than designers) You could also use some better balanced subdivision. For instance, if you have some numerical Id nb, use the three last digits as the file name, and the rest for the directory. This way, when the directory has 1000 files, a new one is created, etc. Use something that cannot be changed in your database, so that you do not have to move the files when data is changed. Category would not be a good choice, since someone may choose the wrong category first, then update the product. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237419 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54