Tracking high traffic clicks and/or page views

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Zoxxa
Forum Newbie
Posts: 1
Joined: Wed Apr 27, 2011 1:11 am

Tracking high traffic clicks and/or page views

Post 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
incubi
Forum Contributor
Posts: 119
Joined: Mon Dec 07, 2009 1:47 pm

Re: Tracking high traffic clicks and/or page views

Post 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
Post Reply