Forum *MUCH* slower since upgrade from 1.1.0

[Mach8]

I honestly can't think what's causing this, everyone on my forum is complaining and I really need to fix whatever is wrong

Since I upgraded to 1.3.0 everything on the forum is a lot slower... one forum user told me a thread took ten minutes to load, others are saying that the threads take so long to load that they just give up.

The number of members and messages on my board has been increasing at a steady rate ever since I first installed Y1G, so there has been no "sudden surge" in hits etc that might be causing the slow-down.

Has there been any major query changes in 1.3.0 that could be causing it to slow-down like this?

Finally, here's some statistics that I myself have noticed:

Average thread load time with 1.1.0: several seconds
Average thread load time with 1.3.0: thirty+ seconds

One of my moderators who previously praised the forum for being "lightning fast" now thinks it is incredibly slow.

 

[David]

My 1.3 forums seem fast.  How big is yours?  But this forum is fast or at least no slower than before.

[Jeff Lewis]

That's horrible  Check the Bugs 1.3 board and a ne sticky post about slow SQL queries has a little bit of a solution in there.

[andrea]

Yes, check if building db indices as described in that thread helps.

Here is the link:
http://www.yabb.info/community/index.php?board=163;action=display;threadid=6599

[mediman]

don´t think that it will be fixed with indexes!

2 maybe 3 seconds okay, but half a minute? have you checked your mysql logs? have you delete big parts of your db? which version of mysql are you using, maybe table will not be optimezed (older versions)!

[andrea]

Mediman, maybe you are right. However Rbuttons got 45 seconds improvement by adding the indices as he wrote in his post, at least I understanding so. I think the indices area worth a trial.

[groundup]

I am learning more and more about mysql everday.  Will these indices add server load (minimal still counts)

[mediman]

yes indexes he has so or so to add! but i mean maybe there is a "additionally" prob! hmm, i think i have to learn english

[mediman]

indices add server load

[Mach8]

Okay, I'll give adding the indexes a try...

I don't have direct access to the mySQL logs, but I've changed nothing in the database structure. I also optimize my tables once a week.

I'm wondering it it has anything to do with the new online indicators, as some threads with a lot of posts must have no end of SQL statements to go through, getting the user's current online status. Just a thought.

[Joseph Fung]

It has to do with a number of modifications that were made.  Ask jeff - I've spent the last month complaining to him about some of the innefficient code that was added while I was in China  

Not that my code was great, but some of the mod writers weren't careful at all with the number of queries they were putting in.

[Jeff Lewis]

There wasn't that much added to make it THAT slow.  I'd make sure track hits was turned off for one, I've noticed that slow things down.

Also, have a link to it?

[Mach8]

Yup, http://dynamic3.gamespy.com/~st/forum/?

I have track hits enabled, but when I upgraded I didn't know what I meant, so just installed it thinking it would be of benefit. What exactly does it do?

[Joseph Fung]

Mach8 - from here, your board is running REALLY fast!  what's the problem?

[Mach8]

Most likely because since the original post I've added the indexes that were mentioned, optimized my tables and disabled hit tracking.