XF 1.4 Performance issue after upgrade to 1.4.1

[RyanC]

So I just upgraded a large forum from 1.3.5 to 1.4.1. Immediately after, the forum is running slow... Is there some kind of upgrade process that is running in the background that is making this thing slow? Or should I be worried?

Thanks,

Ryan

 

[Paul B]

Once the upgrade has completed, that should be it.

Are you sure it isn't server related?
I just loaded your main site page which isn't XenForo and it took a long time to load.

You could try disabling add-ons to see if that makes any difference.

 

[Mike]

There is also this change: https://xenforo.com/community/threa...ading-database-performance.82725/#post-823355 (Which is coming in 1.4.2 as well)

 

[RyanC]

Still having issues... I talked to my host (who is awesome) and he had this to say:

Something major changed with XF in the new update.

Have you heard anything from XF regarding their new upgrade?

We seeing a lot of table locks and and 1.4 million joins without indexes.

Which means the app has to write it to disk and is much slower...possibly the xf guys missed an index?

Any ideas guys?

 

[Paul B]

That's what Mike was referring to in his post above.

 

[Mike]

If they have numbers like that (which would generally be logged in slow queries or via EXPLAIN), they should be able to give more specific details of what those queries are and thus would allow us to comment.

But if you haven't made the index change referenced above and you're seeing performance issues, you really should.