Re: NT IIS number of files limit
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49838
interpreted = N
texte = Lester Emo wrote:> Is there a limit on how many files can be in an NT folder before things > get iffy overall?I am not aware of a hard limit (or even a soft one), but the overhead involved in searching for a file in such a large directory is not insignificant (whatever you, do don't try and display that directory in Explorer). What we do with our cover art (book publishers) is to store them in a simple hashed directory structure with the following WebDNA code:[text]jpgpath=[grep search=^([0-9][0-9])([0-9][0-9][0-9])[0-9X]*&replace=\1/\2/][SKU][/grep][SKU].jpg[/text]so for example if the SKU is 0742526992, the path to the image will be 07/425/0742526992.jpgIn reality, we also have small and large versions of the image, so there is a prior S/ or L/ depending on whether you are looking at the thumbnail or full size image. I have a Perl script which automatically places the file in the correct directory based on the file name. We also store the images on a *nix server so the file system is much more efficient with regards to large numbers of files.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Lester Emo wrote:> Is there a limit on how many files can be in an NT folder before things > get iffy overall?I am not aware of a hard limit (or even a soft one), but the overhead involved in searching for a file in such a large directory is not insignificant (whatever you, do don't try and display that directory in Explorer). What we do with our cover art (book publishers) is to store them in a simple hashed directory structure with the following WebDNA code:[text]jpgpath=[grep search=^([0-9][0-9])([0-9][0-9][0-9])[0-9X]*&replace=\1/\2/][SKU][/grep][SKU].jpg[/text]so for example if the SKU is 0742526992, the path to the image will be 07/425/0742526992.jpgIn reality, we also have small and large versions of the image, so there is a prior S/ or L/ depending on whether you are looking at the thumbnail or full size image. I have a Perl script which automatically places the file in the correct directory based on the file name. We also store the images on a *nix server so the file system is much more efficient with regards to large numbers of files.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat and Mac OS X Server problem (2001)
Need help!! on searching in two databases. (1998)
Memory Error message (1998)
Erotic Sites (1997)
[WebDNA] Open Source CMS (2012)
Stopping bad HTML propagation ? (1997)
Online magazine- monthly updates and such (1999)
HTML Email and Images (2004)
problem: search crashes webstar (1997)
Duplicate Messages (1998)
WebCatalog on Linux (2000)
Username for Admin Group (1997)
[BoldWords] WebCat.acgib15Mac (1997)
Tax Moratorium Expiring (2001)
PIXO support (1997)
Status? (2000)
off topic, converting mail (1998)
[WebDNA] Webdna error on plain html site (2013)
PCS Frames (1997)
Tip for making barcharts (1997)