RE: [PHP-DB] RE: Logging visits using a database

i think i saw an article on phpbuilder.com regarding how to set up a good thing for the path taken - something along the lines of storing IP vs time vs page hit, then a good method for selecting from the db that shows the path of the visitor HTH beau // -----Original Message----- // From: Peter Lovatt [mailto:pjln1@sunmaia.net] // Sent: Thursday, 14 February 2002 4:39 PM // To: Gurhan Ozen; Peter Lovatt; php-db@lists.php.net // Subject: [PHP-DB] RE: Logging visits using a database // // // 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 // info@sunmaia.net // tel. 0121-242-1473 // ----------------------------------------------- // // > -----Original Message----- // > From: Gurhan Ozen [mailto:c-gurhan.ozen@wcom.com] // > Sent: 14 February 2002 03:09 // > To: Peter Lovatt; php-db@lists.php.net // > 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:pjln1@sunmaia.net] // > Sent: Wednesday, February 13, 2002 6:29 PM // > To: mysql@lists.mysql.com; php-db@lists.php.net // > 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 // > info@sunmaia.net // > 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 <mysql-thread99918@lists.mysql.com> // > To unsubscribe, e-mail // > <mysql-unsubscribe-c-gurhan.ozen=wcom.com@lists.mysql.com> // > 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