Related to ongoing conversation about optimizing 202 or CPVLab, can people open up a bit and share what sort of traffic you are driving in daily basis and if, in which point you have noticed your tracking software starting to lag?
I think it would be useful for beginners to know what they can safely push before they need to start sweating about getting dedicated & tweaking and stabbing.
I'm doing mid XXX to low XXXX daily (depending whether I'm testing or not, usually yes) and at least for now CPVLab in 1GB RAM VPS has worked fine. I'm also using MariaDB instead of MySQL which should give some improvements out of the box.
I like to clean out my database every 3-4 days, depending on the volume. I use cpvlabs though which doesn't seem to clog as fast as p202, I'd just get rid of the data on the server you don;t need anymore cos its gonna lag ya a fair bit