Personally, I'd store them in a database, but that is strictly just my opinion on how I would do it. Just for the hell of it, I coded an entire site from cfdirectory listings and cffile reads, writes, deletes and appends, no database whatsoever. Surprisingly enough, the processing numbers were pretty low and performance was failry descent as well ( yeah i was bored )
A couple of the larger, more extravegant components were slighty slower than the SAME component running off of a database, but nothing major. So, I'd have to say using cfdirectory to list the files associated with one emailID at a time would not be noticable as far as performance is concerned Have fun... ----- Original Message ----- From: "Cedric Villat" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 8:45 PM Subject: CFDirectory overhead? > Is it safe to use CFDirectory? Does it have any performance issues that I > need to know about? I'm going to use it to search for certain files. For > example, I want to save all attachments from an email as > #email_id#_#filename#. If I did a <cfdirectory> listing searching for all > attachments that match #email_id# does this have a huge overhead? Or would > it be better to store these attachments in a database? > > Cedric > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
