prosper202 is so slow in showing stats
- Thread starter tom29944
- Start date
Remove campaigns you are not running anymore, helped me to speed up quite a lot. Especially after having several hundreds of thousands of clicks in those old camps.
archiving your prosper202 data for speed | online affiliate marketing
This is what I've been doing, noticed that it speeds up redirects too if you frequently remove clicks from your T202 DB.
This is what I've been doing, noticed that it speeds up redirects too if you frequently remove clicks from your T202 DB.
Your bigger problem is your redirect speeds are probably taking a hit... clean out your database and you'll probably see conversions increase.
I haven't found a good solution to this though other than manually exporting data to a csv daily then using the delete clicks button in the admin section. Been meaning to setup a script to automate this. I also have a daily cron to fix and optimize the tables. Not sure how much that helps, but was recommended at some point.
This is a huge PIA if you need to go back and analyze the data across all your csv files.
I haven't found a good solution to this though other than manually exporting data to a csv daily then using the delete clicks button in the admin section. Been meaning to setup a script to automate this. I also have a daily cron to fix and optimize the tables. Not sure how much that helps, but was recommended at some point.
This is a huge PIA if you need to go back and analyze the data across all your csv files.
About redirects, here's what I've been doing lately. Instead of having the prosper's own redirect scripts I use this code to manage my high volume campaigns:
Code:
$subid = $_COOKIE['tracking202subid'];
if ($subid != "") {
mysql_query("UPDATE 202_clicks_record SET click_out = '1' WHERE click_id = '$subid'");
}and then redirect with php header()
What this does is it manually updates the click in prosper DB that got the clickthrough.
PS: I haven't split tested this against prosper redirects I also need to use it for other reasons but it seems it helps with redirect speed.
Do you do it daily no matter what or do you wait to hit a certain DB size before exporting it?
