YAFLogo

Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
13 years ago
Do we have anything on the database preventing it from Shrink? I tried and it failed with some MS error telling about serialization and encryption. I can attach the screen show here if required.

What tables are involved when we refresh the forum page clicking on the Forum link on the main page? When I do that it gives me a terrible delay up to 20 seconds and even longer, while other pages are ok. Do we need to add some indexes? If so then to what tables and columns?


Dimi

UserPostedImage

Sponsor
tommy382
13 years ago
What version of YAF are you using?
Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
13 years ago

What version of YAF are you using?

Originally Posted by: tommy382 

YetAnotherForum.NET version 1.9.5 RC1 (Date: 10/4/2010).

And the interesting fact is - sometimes it works just perfectly. I guess when SQL Server is not so busy, but in the worst periods the refreah takes up to 27 seconds.


Dimi

UserPostedImage