If you don't want to tackle BLOBS, simply split the images into several directories. 
For example, use the least significant digit of the productID or imageID as a 
subdirectory name.

At 11:16 PM 12/14/00 -0700, Dick Applebaum wrote:
>At 12:25 AM -0500 12/15/00, Dave Watts wrote:
>>  > ... I am told there is a 500 file per directory limit on NT ...
>>
>>This isn't true. I've seen directories with more than 50,000 files on NT.
>>With NT or even with Solaris, though, this can cause performance problems.
>
>Sorry to pass on untrue rumors!
>
>Is there a practical limit, though?
>
>Does this (a 50,000 entry directory) cause problems with things like 
>doing a directory listing with an FTP program? Or, Adding, deleting 
>retrieving an individual file from FTP or CFFILE?
>
>When, if ever, does it make more sense to store the images as blobs 
>in a db... probably in a separate child table (where it would only be 
>retrieved when needed), e.g.:
>
>    ImageId      Integer Identity Primary Key.
>    ProductID    Integer References Product,
>    BinaryImage  Image
>
>A db would certainly be a lot easier to manage from a programmer's 
>point of view.
>
>Anyone with some real-world experience?
>
>TIA
>
>Dick
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to