Website Feels Sluggish

[quote=FatelBlade]Title pretty much says it all. Trying to post a post, a comment, or even open the Community Tab seems to hang for a bit. Perhaps I'm spoiled but it is slower than even other MFN websites, such as DOTAFire.[/quote]

[quote=PsiGuard]I'm getting about a 2 second load time for the Community tab but the front page is close to instant. Is that consistent with your load times as well? How sluggish are we talking? Edit: About 4 seconds to post this comment. To be honest I'm not sure if that's abnormal or not. Maybe I'm just a patient person. :P[/quote]

[quote=FatelBlade]Yes, consistent. Nearly instant home page. Community and anything to do with the forums usually hang.[/quote]

[quote=PsiGuard]I'll see if there's anything we can do to reduce load times.[/quote]

[quote=Matt]Thanks for the heads up FatelBlade! I've gone through and optimized a few of the queries, that should provide a noticeable speed boost. Try it now and see how it feels. It may need some additional caching but, the more caching we add the longer it'll take to update, so ideally we do as little caching as possible.[/quote]

[quote=FatelBlade]Feels much more fluid! This is the final test, if this posts well I'll leave it as is if it works, and edit if it hangs. edit: 5 second hang time, I'll try again later after giving the system some time.[/quote]

[quote=PsiGuard]Test. Edit: Also 5 seconds to post for me. Community tab seems faster though.[/quote]

[quote=Matt]My updates were only for loading the community page. Posting comments is totally separate from that. I'll take a look at that as well, see if I can do anything, but it's a bit trickier so it'll take time to dig.[/quote]

[quote=Matt][mention=FatelBlade] try posting a comment now. I found some optimization issues and cleaned the biggest ones up. There's more to do, it's far from instant, but it takes less than half the time it did before. Edit: If you spot any other pages or actions that are sluggish let me know and I can take a look at them too.[/quote]

[quote=FatelBlade]Test number two, if it works I won't edit, if it takes the same amount of time I'll edit.[/quote]