Finally I got the pageload-time for the forums-list back to normal.
With the devel module I found out, that advanced_forum_get_all_last_topics() used to take 25-30sec in execution time in certain cases.
It always happens, if there is a new post (or if there was no reload of forums-list for a long time <- not sure on this one)

What are your execution times for the /forum page?
Do it like this:
Use devel-module or use the Lori Firefox-Addon which stands for life-of-request-info. Very nice tool.
Post a new comment to the forum with a user not equal to #1.
Afterwards load the /forum page with user #1 and see what the execution time is.

My data:
~2400 topics, ~53000 answers. -> 25-30sec for the query in advanced_forum_get_all_last_topics()

Of course this is dependant on network/database/cpu-speed, but 25sec are very crazy.

Comments

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented

Not sure what the point of a poll is? We already know the query is awful and there is already an issue for it. So a poll won't tell us anything new. What I don't know is how to fix it. I'm not a db expert. I didn't even write the query to begin with. I have no clue how to make it better. I'm tempted just to remove it and we'll do without that feature until someone can make me a nice fast query.

Michelle

maulwuff’s picture

maulwuff commented
Status: Active » Closed (fixed)

oh, sorry for that. It did cost me so many of my nerves, I just wanted to collect more info about it :)
I searched 5 pages but, it seems as if I've overlooked the existing post.

poll closed. :-P