YAFLogo

Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
12 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
12 years ago
What version of YAF are you using?
Dimi
  • Dimi
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
12 years ago
Originally Posted by: tommy382 

What version of YAF are you using?



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
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button