Is CPVLab extremely slow to load for anybody else? (14)
I've been pushing high volume over the past few weeks, and ever since I've turned up the volume my CPVLab loads slow as shit. It's frustratingly slow. My internet isn't the greatest, but it's loading slower than any other website. Does anybody else experience this issue with CPVLab?
when's the last time you cleared your database?
Also worth running OPTIMIZE TABLES on your server.
Guys I know it was not a very smart thing to do and If I had a chance I would not do it again, again it was not my intention to to make it sound like I was proud of it, but rest assured neither do I do it anymore but help people out who need accounts.
if it indeed caused the whole tightening I really APOLOGISE!
Thanks for the responses. As far as I know I've never cleared my data base or optimized tables. Will doing this erase any of my data? I don't want to lose anything
Originally Posted by caurmen
Currently my clicks table is about 4GB of size (I think about 15 million clicks) but the redirects are still ok. The only bad thing is that it takes 5 minutes to look at "last 7 days" stats and when I do this the redirects does not work. The solution is to have a second DB that responses only for stat stuff.
Is CPVlab a one time one server install?
Can one uninstall it and reinstall it?
Or move it to another server or domain?
you can move it, or uninstall/reinstall. if you are moving it, just open a ticket with them and let them know your new domain. it can only be run on 1 domain/server per license.
Export your data and clear your tables using Setting > Stats Management > Remove Stats. Yes, it is great to see all the data and run fancy reports in CPVLab, but you are losing conversions if your redirects are slowing down. Also, do not run reports during your peak traffic times.
Yes you really need to clear data pretty often if you are doing high volume and you want the stats to load quickly. The good news is it doesn't seem to impact redirect speed.
loading stats/report with CPVLAB will slow down/break your redirects.
and what's the point of keeping all those stats (4gb is a lot to be honest)? i usually just clear stats 2 weeks ago, sometimes 1 week ago, depending on what vertical you're in and what traffic you running (watch out for pop under traffics)
if you want all your stats, get another cpvlab and a new server.
do you want to loose stats or losse conversions, your call mate..
http://fitaffiliate.com/2012/10/opti...vlab-database/
Thanks for all the replies. I opened up a ticket with BeyondHosting and they suggested that I upgrade my servers. I'll try andy_d's guidelines first before upgrading and see what happens.
@deedsmedia - D'oh. Of course, if they're InnoDB OPTIMIZE TABLES won't help much! Thanks for the correction there.
@starrmikeh - have you optimised your other MySQL settings? Particularly for an InnoDB setup, that can make a huge difference in database speed. I'd recommend doing that before deleting data - it might sort your problem out. Here's my recent tutorial on that - ignore the first bit, but the third part in particular may be very valuable for you.
Home > Tracking Campaigns > CPV Lab Pro