I agree. Log files can be quick and dirty but NOT easy to crunch unless you import them into a database. Memory usage can also suck if you are constantly reading and writing to a text file in some situations. If you are REALLY concerned about performance, use cfthread for the logging so it is asynch, or do your initial inserts into a table with NO indexes, and aggregate the data nightly into some other tables to run you reports off of.
To address the SQLi point specifically, I would necessarily bother logging them unless you are just the curious type (like me). If you do choose to log though, do it right by simply using the database. By the way, if you are storing the URL, make sure you use cfqueryparam when you stick it in your insert statement. :) ~Brad ----- Original Message ----- From: "Mike Chabot" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Saturday, August 09, 2008 6:20 PM Subject: Re: Homebrew logging solutions > Based on what you described, go with a database. A database would > likely have higher performance and the data would be easier to > analyze. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
