News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Table to large, strategies?

Started by Biology Forums, May 04, 2019, 11:23:56 PM

Previous topic - Next topic

Biology Forums

Quote from: vbgamer45 on May 07, 2019, 12:48:59 PM
Can you run and post back show create table smf_releated_topics;
With the change made now.


Here you go!

Thanks for the links, shawnb61

albertlast

Possible improvment would be to use the new version of authority check.
You see:

FIND_IN_SET(-1, b.memberGroups)

since this got no index support,
2.1 changed the code of "query_see_board": https://github.com/SimpleMachines/SMF2.1/blob/release-2.1/Sources/Subs.php#L6559
this version use now index.
Also in rc3 query_see_message_board and query_see_topic_board got added: https://github.com/SimpleMachines/SMF2.1/blob/release-2.1/Sources/Subs.php#L6589
Less amounts of join are needed for authority check.

Advertisement: