All of the information is already in a DB with a very efficient structure. For example, the user agents are all ids rather than strings linked to a lookup table. I'm looking to create different forms of daily, weekly and monthly stats into separate tables for ease and speed but the issue has always been displaying the data. Showing off that browser X has 80% vs. browser Y and bot Z is taking up 15% of all hits. The data is probably useful just to show how many hits the site gets per day, week, etc.
> Are you just talking about something like a log analyzer? Wouldn't it be > better to use something other than CF for that? There are lots of other > software pieces out there to do that. I looked into doing it before but > to read the file line by line and do database operations just seems > extremely inefficient with Cf. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -----Original Message----- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 09, 2005 12:20 PM > To: CF-Talk > Subject: (Admin) Report help > > While looking over some stuff on House of Fusion yesterday I noticed > that I've been logging information since around march and I've had over > 16.5 million page views in that time (about 2 million a month). The > logging has records of what's a bot and what's a human. The problem? No > reporting interface to the data. > I was wondering if anyone here with experience with reporting has a few > moments to devote to writing a report interface to the data. I'll be > giving out the CFC and database structure I use to the community so > whoever helps with the reporting will have their name associated with > the full project. > > You can contact me off list, by yahoo chat or phone for more info or > ideas. > > Thanks > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
