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

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,779
    • 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

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 616
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":
this version use now index.
Also in rc3 query_see_message_board and query_see_topic_board got added:
Less amounts of join are needed for authority check.