One of the best solutions if you want to use CF to analyze the logs is to let the database do the heavy lifting. If you've using SQL Server or MySQL you can use the bulk insert tools (bcp and loaddata) respectively to quickly get the logfiles into a database for further processing. I get 10 MB+ of logs imported in about 15-30 seconds on a PIII 500 laptop when I'm bulk importing, processing/parsing each row to remove extraneous quotes (using REPLACE). There are certainly tweaks that would improve that performance as the logfile increases but its a good start.
I've done some recent work using SQL Server for that purpose and been pleased (< 14 MB of log traffic a day, so small project). I'm also using stored procedures and OLAP to automate and prebuild some of the common reports. MySQL can do most of that as well (as could Oracle, etc). Regards, John Paul Ashenfelter CTO/TransitionPoint [EMAIL PROTECTED] ----- Original Message ----- From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 10:07 AM Subject: IIS logs > Has anyone used CF to read IIS web server logs and compiles the info similar to Livestats or Webtrends? If so, would you mind sharing some of the code that reads the comma-delimited file log file, etc? > > or...is there a CF-based program out there that reads IIS logs and compiles the info? > > Thanks. > > Robert O. > HWW > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
