One of my main gripes with CPVLab has been speed issues. Not necessarily the speed of the redirects or anything, but the speed of running queries in the stats. I’ve been using it since it came out, and up until last week, I never really deleted any data. Over that time the database became quite a large mess.
For example, running a Trends report would take a number of seconds, if not minutes, to complete. Or running a Stats report for the month. During this time, my redirects for campaigns weren’t working because my server was busy thinking about that Trends query, thus serving empty pages to people.
Now I don’t know if I could blame that on CPVLab specifically, or my server set-up. Either way, it was an issue that bothered me because it just took forever.
Yesterday or maybe 2 days ago, CPVLab 2.10 was released. It seems like these speed issues have been addressed. Stats and Trends show up with the quickness so I’m not sitting around twiddling my thumbs.
Since I’m not a real reporter and I’m lazy, I haven’t asked the CPVLab guys if they addressed these issues specifically. But I have been crying about it to them for a while, so I’m assuming those cries didn’t fall on deaf ears.
If you run your own server, definitely check out MySQLTuner. It’s a handy script that gives you tips on improving your mySQL settings for performance. I am an absolutely retarded server admin, so using this helped me out a bit. If you’re an advanced server admin, then I await your condescending remarks about how retarded I am and that I shouldn’t be using Apache to deliver mad pops.
Anyway, CPVLab is still the shit and now it’s much better. You should definitely be using it if you’re doing PPV (unless you’re special and have rolled your own tracking software).
Despite all this, I’d still recommend a full re-install of the software every few weeks. I don’t care how slick any software is. Once you have millions of queries in a database, you’re wasting precious milliseconds of server time running database queries that could be spent delivering pops. (Insert more condescending remarks about the cloud, load-balancing, and other nerdy topics)