> One point I am curious about, is what kind of file structure you use to 
> store the millions of images on the filesystem.  I can't imagine that 
> you do it really into one flat directory ?

Thanks for the response. 

We use the 'md5' scheme in CGI::Uploader. From the docs:  
  "[We] will create three levels of directories based on the first three letters
  of the ID's md5 sum. The result may look like this:"
    2/0/2/123.jpg" 

> And are you storing the real paths directly in the database ?

No, we generate the path based on the unique ID. 

You points were all interesting and steer me back in the direction of trying to 
better
understand and eliminate how inconsistency is creeping into our system.

    Mark

-- 
 . . . . . . . . . . . . . . . . . . . . . . . . . . . 
   Mark Stosberg            Principal Developer  
   [EMAIL PROTECTED]     Summersault, LLC     
   765-939-9301 ext 202     database driven websites
 . . . . . http://www.summersault.com/ . . . . . . . .



Reply via email to