Page 1 of 1

Tracking high traffic clicks and/or page views

Posted: Wed Apr 27, 2011 1:13 am
by Zoxxa
Hello!

I am an internet entrepreneur. Due to bad experiences with hiring programmers, I have taken the liberty to teach myself enough PHP to get what I need done, however I need some assistance or advice if possible..

I have a network of websites where some of them individually will have 100,000-400,000 visitors per day. A VERY important part of the websites will be sorting the most popular clicked media. I would like to know the absolute best & simplest way to accomplish this.

I believe updating the mysql DB on every click for every page is very overkill, and I do not want to use the server logs and parse the data. The only idea I had was to store the data in flat files, and cron it every hour to update the DB in one shot.

Ideas?

I appreciate it! :o

Re: Tracking high traffic clicks and/or page views

Posted: Fri Apr 29, 2011 3:16 pm
by incubi
Hi, not sure why you would want to create a flat file when your logs are already there and are flat files but...

One option would be to use web reporting that your ISP offers if they do. Or if you are your own ISP install a reporting tool and customize it for what you want. Also tracking every click on every page into sql is not a big deal if its done correctly.
And what I mean by that is you cache the info and do an insert say every hour or so.
If it were me I would use the logs that already have the info in them.


Lee