Prosper202 Limits?

Status
Not open for further replies.
Mike

Mike

New member
Jun 27, 2006
6,777
117
0
51
On the firing line
Has anyone experienced problems with P202 slowing down / dragging when their click count gets too high?

I've run over 200,000 clicks through the system in about 7 - 10 days, and I'm starting to notice it's taking a lot longer to run queries and whatnot. I guess that makes perfect sense, the database has more data to sort through.

Luckily, all the redirects are still fast and are not timing out or failing in some other manner.

I guess what I'm getting at is: at what point should I consider another option? and what options are there? I'd like to hear from anyone that has used DoubleClick's Dart for Advertisers or MediaPlex or AdJuggler.
 


SEO_Mike said:
Has anyone experienced problems with P202 slowing down / dragging when their click count gets too high?

I've run over 200,000 clicks through the system in about 7 - 10 days, and I'm starting to notice it's taking a lot longer to run queries and whatnot. I guess that makes perfect sense, the database has more data to sort through.

Luckily, all the redirects are still fast and are not timing out or failing in some other manner.

I guess what I'm getting at is: at what point should I consider another option? and what options are there? I'd like to hear from anyone that has used DoubleClick's Dart for Advertisers or MediaPlex or AdJuggler.
Click to expand...
Get a better server, you're running it on a dedicated right?
 
You could look into Omniture. They have a number of good modules that work really well once they whole system is up. However getting everything setup is a pain for agencies, since we need to be able to show our clients only certain data pertaining to their account, but I don't imagine that would pertain to you.

So if you can get it setup, you'll have one of the most powerful systems out there.
 
Yeah, it's dedicated with dual quad cores. Not even cracking 1.0 for load. That's what makes me suspect the database either isn't optimized or is just getting too big.

Fuck clients, they are a pain in the ass. I have one boss - me (and my partner...oh and wife). So, I only have 3 bosses (unless you could myself and I, then I have 5) but whatever, they can all look at the data, so that's fine.

I've actually had a chance to mess with Omniture before in a web analytics role. Very complete stuff there. Thanks for the tip!
 
SEO_Mike said:
Yeah, it's dedicated with dual quad cores. Not even cracking 1.0 for load. That's what makes me suspect the database either isn't optimized or is just getting too big.

Fuck clients, they are a pain in the ass. I have one boss - me (and my partner...oh and wife). So, I only have 3 bosses (unless you could myself and I, then I have 5) but whatever, they can all look at the data, so that's fine.

I've actually had a chance to mess with Omniture before in a web analytics role. Very complete stuff there. Thanks for the tip!
Click to expand...

They are using MySQL which is a good option for small-medium sized databases (when optimized right) but for big ones.. its not the best...
But still 200,000 is not that much.. I guess you should talk to them and see whats what..
As for other options... well if you read my signature you'll see I'm pretty biased ;)
 
Mike - Upgrading to 5.1 might solve your problem.

Warning: Recommended MySQL 5.1 or later, not detected.

You are about to install Prosper202 on a server that does not have MySQL 5.1. You can run the application just fine without MySQL 5.1, however, MySQL 5.1 has a horizontal partitioning feature that dramatically increases the speed that large click reports are generated. If you are an affiliate pushing over 5,000 clicks or more per day, we highly recommend you install Prosper202 on a dedicated server that has MySQL 5.1 or newer installed on it. You may continue installing Prosper202 without MySQL 5.1, but once you have around 250,000 clicks recorded in your database, you will start to notice a significant reduction in speed that your click reports are generated. If you are someone not pushing heavy volume yet, you are probably fine without MySQL 5.1 for now, but you should look to upgrade to a dedicated server with MySQL 5.1 at a later time.
Click to expand...
 
  • Like
Reactions: Mike
xxmwxx said:
They are using MySQL which is a good option for small-medium sized databases (when optimized right) but for big ones.. its not the best...
Click to expand...

That's bull. MySQL is running some of the largest sites on the net. Facebook runs on MySQL.

I run my web stats service, W3Counter, on MySQL. It handles over 400 queries per second and generates over 10 million new rows of data per day.
 
Dan Grossman said:
That's bull. MySQL is running some of the largest sites on the net. Facebook runs on MySQL.

I run my web stats service, W3Counter, on MySQL. It handles over 400 queries per second and generates over 10 million new rows of data per day.
Click to expand...

What kind of queries are you running on it? Inserts/updates/simple selects are cool.. but more advanced stuff usually chocks and a lot of times the indexes/tables got screwed up for me at least. But anyway.. like I said 200k is too little plus it depends on how you manage the DB. And just to be accurate FaceBook does run on MySQL but they have thousands of servers/databases running...
 
Dan Grossman said:
That's bull. MySQL is running some of the largest sites on the net. Facebook runs on MySQL.

I run my web stats service, W3Counter, on MySQL. It handles over 400 queries per second and generates over 10 million new rows of data per day.
Click to expand...

good way to work in a plug for your site ;)
 
Status
Not open for further replies.
Top Bottom