Thanks. Analog only does basic 'what files have people viewed?' type reports, which offers some of the insight I am looking for, but not the path through the site etc. Also the output confuses non techies. Any other thouhts?
TIA Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > Sent: 14 February 2002 03:09 > To: Peter Lovatt; [EMAIL PROTECTED] > Subject: RE: Logging visits using a database > > > Hi > I have never used it but sounds like analog would fit your needs pretty > well. Check them out at: > http://analog.sourceforge.net/ > > Hope this helps.. > > Gurhan > > > -----Original Message----- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 6:29 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Logging visits using a database > > > Hi > > Excuse the cross post > > I am thinking about building a logging tool to do visit analysis > using SQL, > rather than doing log file analysis. > > The aim is to analyse requests for dynamic pages called via php as well as > static pages. Static pages will use an include for logging. Php calls may > have two or three extra parameters which relate to products that are > displayed (this is for ecommerce) which I also want to log. I am looking > particularly at HTTP_REFERER, paths through the site, and most viewed > products. > > Questions > > 1. Am I reinventing the wheel? and would it be better to buy a package > (Spending money brings me out in a nasty rash, and leaves me feeling a > little unsteady on my feet, but is sometimes the best option), or > use a free > one. The intended audience is non technical managerial type bods > so nothing > too difficult to understand :) > > 2. If I do use an existing package, are there any that are good > with dynamic > sites and the parameters passed to scripts, rather than just > logging static > pages? > > 3. Writing a database driven stats package on a medium traffic site (3-500 > visits a day, Average 8-12 pages per visit=6000 inserts a day, peaking at > 2-3 per second ) will mean lots of inserts, and a few reads when the > analysis is run. Running MySql on a 1.5GHz 512MB machine, is it better to > leave the table unindexed and put up with slow analysis, or will > the machine > cope with indexes? The data could be aggregated periodically, but if > possible left intact for up to a year to follow trends. > > 4. Is a (MySql?) database driven system a good answer, or just > the wrong way > to go?? > > Any thoughts and experience much appreciated before I commit to hours of > work and gallons of coffee > > Thanx > > Peter > > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
