Performance Issues w/Large # of Affiliates

[Alexd]

Hoping that I can get some guidance on any performance issues we can expect as we import affiliates.

We have 11,000 affiliates to import on a high traffic site. Where are the performance issues? I cannot find any information on this.

This is a live high traffic site so hoping not to discover after the fact that PAP4 cannot scale.

Thanks!

[Alexd]

Should also add this hosted on a quad core dedicated server w/6gb ram. Problem is that we also run our e-commerce app on this server and do not want performance of the cart to suffer as a result of importing too many affiliates.

Thanks!

[Alexd]

Anybody care to comment or point me to documentation regarding the performance impact of number of affiliates in DB?

I have search the forum many times over and there is nothing to be found here on that.

Thanks!

[aharsani]

PAP4 can work with more then 1mil affiliates, so 11.000 is definitely no problem.

We have done several performance tuning optimizations.

[Alexd]

Can you guys post some of the results from these performance tests?

Maybe the DB can hold 1mil affiliates but what is the impact of 1 mil high traffic affiliates with impression tracking served from apache? How about if they all log in at one time?

Would be great to show x# of affiliates per GB of free ram with some numbers on average impressions, banners served and clicks.

Maybe a guide to increasing performance.
- banners served from CDN (Amazon, SimpleCDN, etc.) - "change this setting that will not get overwritten in upgrade" or provide a plugin even
- "Program (or portions) hosted on NGINX server this way"

Would be great to see this kind of info so that we know this is a serious program and thought has been given to scaling for high traffic sites.

Thanks!

[Alexd]

Been many months since this was posted and no final response. Anyone care to comment on last post about improving performance?

Thanks

[online]

Hello Alexd,

i was looking this question and answer but when i see your topic i want to tell something.

I have a advertisement network and i am using some script.We had also some problem about server and apache webserver.Request was very high and apache was down.I can offer you use LiteSpeed ( [url]http://www.litespeedtech.com/[/url] ) I really can feel the differences.As i understood your request is very high with 11.000 members.So in my opinion your apache is create a queu for the after 256 request currently.Becaouse of this you may wait the response.

[Alexd]

Thanks for your response. Were you able to move parts of the application to lightspeed or just the entire script? Ideally would like to have images and client code served from nginx/lightspeed while fine to have client from apache.

Would be great if developers could join discussion.

Best,
Alex