Regarding:
The problem with many files in a directory:
Another possible algorithm:
Simply name the blob using the ROWID, e.g. Image00000783.png
In ancient days, a DOS directory of several hundred files might bog
things down, but you can put thousands into a modern O.S.'s directory if
necessary. So even though you can't predict the exact size of the
customer's data, you can probably get the maximum order of magnitude --
and that's all you need.
For example, you could create a two level directory structure of 100
directories as:
/0/0/
/0/1/
/0/2/
etc., up to /9/9
Then, a blob with ROWID of "783" could be stored in directory /8/3/.
(Alternately, if you want to allow for future three-level, four-level,
etc, you could
store it in /3/8/ with the first directory chosen for the LEAST
significant digit, etc.
and get better dispersion.)
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
