What are any of these homebrew page view scripts performing that can't be derived from the webserver logs?
Webtrends sells their Log Analyzer for $499. How many development hours will you spend before you've spent more than $499 of your time? The reporting functionality of WebTrends should be able to show you all the bits of information you were looking for. CF is hella powerful, and can do just about anything you'd want it to, but reinventing the wheel doesn't have to be one of them. Just my two cents... t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:09 AM To: CF-Talk Subject: RE: Efficient Logging Application Jim I do the following to keep track of hits, monthly to my web pages: I have a table to hold the current monthly web pages info and an identical historical table. I call a tag that checks to see if the page is already in the table if not it creates a record with hits=1 I also maintain a session.pageshit. This is an array of pages that the current user has viewed, so if a user visits a page more than once in a visit, its only counted once. On the first of the month I have a scheduled task (cfm page) that transfers the month just ending information into a historical table and then cleans the current table to start over for the new month. Just one way, hope it helps with ideas Rodney -----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:34 AM To: CF-Talk Subject: Efficient Logging Application I need to log views of dynamically generated pages in a MySQL database. We're just going to be logging on a monthly basis, so this means that each page will have one log record per month. A couple of ideas we're kicking around: 1. Every time a page is accessed on the site, we'll call a CF tag that will: Look to see if a log record exists for the page If it does increment the 'views' column else create a new record, with views=1 Since the record creation is only done on a monthly basis, this means that the vast majority of tag calls will simply do an update, yet must still do two queries, the first to see if the record exists. 2. Create all of the log records before-hand, on the first of each month. Biggest problem with that is that new items are constantly being added to the database, so new pages are possible. Since items are pulled from a couple dozen tables, with a couple dozen distinct maintenance applications, we'd need to modify those applications to add log records as new records are created. That's a lot of work. 3. Instead of updating a monthly log record directly, we thought we might just do an insert into a table of a new record for every single page view. At the end of the day, all the daily records would then be 'rolled' into the monthly logs. This way, no SELECT query is necessary. Not too sure of the relative efficiency, however, of an INSERT every time versus a SELECT, then an UPDATE. Any ideas or insights would be appreciated. Jim ______________________________________________________________________ Get Your Own 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=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists