maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
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

Re: maximum number of files in directory

2006-04-11 Thread Thomas Chiverton
On Tuesday 11 April 2006 13:42, Gilbert Midonnet wrote: It is quite possible that there could be 15-20,000 images in this directory. Is that too many? I would say so. You may want to break it down into subdirs by initial character, 2nd character, and then the file or something. That is how

Re: maximum number of files in directory

2006-04-11 Thread Claude Schneegans
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

RE: maximum number of files in directory

2006-04-11 Thread Shepherd, Brandon
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

RE: maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
: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

RE: maximum number of files in directory

2006-04-11 Thread Mike Klostermeyer
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

RE: maximum number of files in directory

2006-04-11 Thread Dave Watts
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

Re: maximum number of files in directory

2006-04-11 Thread Jerry Johnson
I often use the itemID to break down the folders, since these seldom change. Since it is the computer and not humans that do the sorting, the rules can be simple for the computer, even though weird for people. The last 3 digits of the zero padded id has worked well for me.

Re: maximum number of files in directory

2006-04-11 Thread Ken Ferguson
[mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 10:19 AM To: CF-Talk Subject: RE: maximum number of files in directory ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237426 Archives: http

Re: maximum number of files in directory

2006-04-11 Thread John Paul Ashenfelter
On 4/11/06, Gilbert Midonnet [EMAIL PROTECTED] wrote: 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

RE: maximum number of files in directory

2006-04-11 Thread Burns, John D
, 2006 12:01 PM To: CF-Talk Subject: Re: maximum number of files in directory A customer of mine had a Windows 2K server on a cheesy little box. It had about 15,000 images in one folder and was still serving them up without much if any problem. However, I made the mistake of trying to open the folder

Re: maximum number of files in directory

2006-04-11 Thread Claude Schneegans
I'll probably do something along the line you suggest but probably bring it down to 100 or 250 instead of a thousand. Time to use the MOD operator then ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm

Re: maximum number of files in directory

2006-04-11 Thread Jochem van Dieten
Gilbert Midonnet wrote: 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

RE: maximum number of files in directory

2006-04-11 Thread Gilbert Midonnet
: maximum number of files in directory Gilbert Midonnet wrote: 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