Do large threads slow town the average forum speed?

At my forums there ar threads with more then 17000 posts.. Is it possible these threads are slowing the complete forums down?

I have about 170 users online now, only 3 of them are using the search function.
But my server loads vary from 1.20 - 3.20.. And the forums are extremely slow.

[Karri]

Originally Posted by Erwin

The answer is yes.

I limit all my threads to 1,000 posts (automatically split and linked). Reduced my load about 3 years ago when I started doing this by a lot.

I would love to see how you did this as well. It would save my mods sooo much time if that was done automatically.

[rossco_2005]

I've got a thread that has almost 47,000 replies now (like 100 or more posts per day in it so it's pretty busy).
It doesn't seem to slow my forums down any but viewing the thread does take a while.
It takes about 2 seconds to load while any other thread would take 0.4 seconds...

[Eagle Creek]

Originally Posted by Shazz

Ok lets say your forums were faster..
Whats the difference between "it seems faster" or "its faster"
Can you tell?

Of course!
This hack removes the flash between pages. That works when a page loads in about 1-2 seconds.

When it takes more then 10 seconds to load a page, this flash isn't going to help ANYthing.

I want to have my forums faster, not to seem faster. And.. Not all my users are using the same browser.

Originally Posted by rossco_2005

I've got a thread that has almost 47,000 replies now (like 100 or more posts per day in it so it's pretty busy).
It doesn't seem to slow my forums down any but viewing the thread does take a while.
It takes about 2 seconds to load while any other thread would take 0.4 seconds...

Ok.. I see. But how many users do you have online? And how many of these threads you have? And how many post per page?

[rossco_2005]

Originally Posted by Eagle Creek

Ok.. I see. But how many users do you have online? And how many of these threads you have? And how many post per page?

"Currently Active Users: 667 (91 members and 576 guests)"
This is about the average.

There is only 1 thread that large, there are others around 4,000 posts.

We would have more but only in the last year started allowing over 1000 posts.

[Erwin]

Check your slow_query log and see which threads show up most often in there.

[Eagle Creek]

Where can I find that log?

[Erwin]

Originally Posted by Eagle Creek

Where can I find that log?

You need to enable slow_query logging in my.cnf. It would be on your server.

[Eagle Creek]

I don't have an item called 'slow_query'.