Front Page Loads Very Slowly · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

RDarling
56% (Neutral)
YAF Camper Topic Starter

14 years ago

This forum is setup for a university. We are running yaf 1.9.301. Every session (4 times a year) we remove all of the forums (except for about 4 forums) and their topics and we recreate new forums for the new classes of the session. In the past I have been able to manually go to server (SQL server 2005) and reindex the databases and then front page would load quickly again, but this time it still loads slowly.

This is what shows up when I compile in debug mode:

[dbo].[yaf_forum_listread]: 44.132

So it is taking anywhere from 40 to 50 seconds on average to for the yaf_forum_listread query to load. I have tried using the ReIndex DB in the admin part of the forum but it has never seemed to do anything. I am not sure if it matters or not but currently there are 5 categories with 116 Forums total. Thanks in advance for any help.

Rob

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

14 years ago

SQL Server IO issue. Get someone in there who understands servers and SQL server to fix that issue.

RDarling
56% (Neutral)
YAF Camper Topic Starter

14 years ago

SQL Server IO issue. Get someone in there who understands servers and SQL server to fix that issue.

Originally Posted by: Jaben

We have about 10 other databases that are running on the same server just fine. Would the IO issue just affect that 1 database?

Important Information: