Well, I always find CFFILE to be pretty freaking slow, so I'd go with the database log.
-----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 8:15 PM To: CF-Talk Subject: CFFILE vs database for logging I'm working on a site where a number of protected pages will be serve d up using CFCONTENT from outside the web root. Obviously these pages a re not going to show up in normal web site statistics programs. I'm thinking of writing my own logs for these files. I figure I can either write to the database every time a page is requested, or I cou ld append a text file every time. Which would be better from a performan ce point of view? I think that the database would be faster than CFFILE, but does CFFILE wait until the file operation is finished? If not perhaps that would be quicker. Or is there any other way to do it? I' ve thought about storing the data in an application variable, then dumpi ng it to the database (or a text file) at a specified interval. Any thoughts? Kay. ______________________________________________________ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd http://developer.perthweb.com.au - Tools for Developers cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcrypt _____________________________________________________________________ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
