[eluser]egoslip[/eluser]
alright so lets say I have 1,000 pages and I would like to track how many page views via set intervals like pv-today | pv-yesterday | pv-last7 | pv-last30 | pv-alltime. whats that best way to go about inserting and retrieving the view data from the database without having it cause a complete melt down of the db..
my original idea was to have a table for just views where it would count the total number of views for that day IE - id|page_id|views|date - then just use the db sums function to get the counts but then I would be having 1k rows every day one row for every page every day.....
I would love if someone else might have another idea on how to accomplish this with out over bloating the db