Good question. We also run a web log analyzer. There are a couple of things that a web stats package can't do for us. First, if it's not storing data in a database that we can query, then we're limited in the types of queries that we can do, and we're limited to the particular presentation of the stats package. We also run multiple web sites, and conglomerating multiple sites is usually a fair amount of work with most web analyzers. I haven't work with WebTrends in several years, so it may be easier than with some others.
The biggest hurdle for us, however, is that because these pages are all dynamically generated, and we don't use standard url variables, then the information isn't even stored in the web logs. Jim ----- Original Message ----- From: "Tyler M. Fitch" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 12:23 PM Subject: RE: Efficient Logging Application > 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 ______________________________________________________________________ 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
