Advertisement:

Author Topic: Table to large, strategies?  (Read 2001 times)

Offline Study Force

  • SMF Hero
  • ******
  • Posts: 3,599
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: Table to large, strategies?
« Reply #40 on: May 08, 2019, 10:29:33 AM »
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

Online albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 548
Re: Table to large, strategies?
« Reply #41 on: May 10, 2019, 05:42:14 PM »
Possible improvment would be to use the new version of authority check.
You see:
Code: [Select]
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.