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
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
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
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
: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
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
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
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.
[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
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
, 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
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
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
: 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
14 matches
Mail list logo