PDA

View Full Version : Performance implications for large number of replies per thread?


Kevlar
Wed 12th Jan '05, 6:51pm
Does anybody know of the performance implications for threads with a large number of replies? I was told that when threads reach a certain size, the performance hit the hardware takes for those threads starts to get exponential.

I've always considered 500 replies large, but I was wondering if this was true or not and if I should start splittin my threads earlier... 150-300 replies?

Thoughts?

Jake Bunce
Thu 13th Jan '05, 12:47am
I'm not sure. I am moving this to the Server Configuration forum.

Erwin
Thu 13th Jan '05, 6:41pm
The COUNT query to list out the number of pages causes the query to be slow. I limit my threads to 10,000 replies, but really, that's too many replies - should be 1-5,000. I had a thread with 60,000 replies that was killing my server. :)