Q:

How to manage a pageview DB

I am interested in tracking my users' pageviews on my site. Being that traffic is expanding very quickly, I am worried about robots, etc, and I also want to be able to use tracked data live to alter the user experience (so, while I do use Google analytics, it does not serve this purpose).
What is the most efficient way to store my information? Here is my current theory, please critique and/or offer more ideas:)
Strategy: Gather ip, page url, browser/version, timestamp, referrals from client on load and insert a row into MySQL. Determine some interval based on time or performance to "archive" the table and either delete rows, or create a new one via cron.
Is this stable? 

A:

Sounds reasonable. You should make that table MYIASM and not have any indexes if you want inserts to be fast as possible.

