yeah Dave.. you and I a while back shared a thread on this.... I can tell you definitely in the Windows world, that outside of doing just the file requests, if you do a directory or maintenace function on a large directory with all those entries, your server is going to be mighty slow... and might even run the risk of crashing if you have load already...
filing in the yyyy - mm format is a good start... go all the way down to third level with dd if volume.. and if mega volume... down to hh :) it might seem like overkill, but its a good habit if you even think any site might grow to a thousand or more uploaded files... Your disk will thank you and me. -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -----Original Message----- From: Dave Watts <[EMAIL PROTECTED]> Date: Wed, 6 Nov 2002 18:24:02 -0500 Subject: RE: Error Processing CFFILE > > The only thing is the folder where the file are going > > is getting extremely large, (over 8 gigs) and I'm > > wondering if that is maybe the problem ? > > It would be a good idea to use subdirectories for this in any case, I > think, > even if it's not the cause of your current problem. I worked on a CF > project > once which had tens of thousands of uploaded files in a single > directory, > and performance seemed to improve significantly when the files were > uploaded > into different subdirectories. If I recall correctly, the scheme used > was to > create directories for year, then within those, create subdirectories > for > month, then for each day within the month subdirectory, before saving > the > uploaded file. It was a pretty simple code change. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
