RE: maximum number of files in directory

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

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

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 (Ple

RE: maximum number of files in directory

2006-04-11 Thread Burns, John D
t: Tuesday, April 11, 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 tryin

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 Ken Ferguson
Message- > From: Gilbert Midonnet [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.houseoffusio

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 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 Mike Klostermeyer
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

RE: maximum number of files in directory

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

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 in

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 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 h