Managing Site Visits In Database

[eluser]skunkbad[/eluser]
Perhaps you can archive monthly records older than 90 days, and then delete them from the table(s)? If you need this data in the future, you could always back up to a local machine for review. If they are auto incremented, archives from month to month could be put back together for analysis.

I use a service, statcounter, and it only allows for the last 500 visitors. Most of the time this is about 10 days worth or stats, because my site is quite low traffic. I review the stats frequently, so the old stats would mean nothing to me. How long do you need to go back?

A while back I was looking to build a custom analytics system too. It would be nice to see your system in the wiki.