xF2 Optimized List Queries by Xon

[ven0m]

Heisenberg submitted a new resource:

You must be registered for see links

- A collection of replacement queries for getting lists of stuff aimed at large forums.

This addon is aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this add-on.

Member List/Forum/conversation lists:

MySQL implements 'early row lookup', when combined with LIMIT & OFFSET with a large offset, results in the large select statement pulling in more data than is required. Maybe one day MySQL will fix this. Maybe.

This causes an issue as this how conversations and threads...

You must be registered for see links

 

[ven0m]

Resource has been updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Shim news-feed to ensure better index handling

You must be registered for see links

 

[ven0m]

Resource has been updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Fixed typo causing "Unknown relation _db accessed on xf_news_feed"

You must be registered for see links

 

[ven0m]

Resource has been updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Fix XF2.1 compatibility issue when viewing recent activity news-feed as a user who is following other users

You must be registered for see links

 

[ven0m]

Resource updated

You must be registered for see links

with a new update entry:

You must be registered for see links

Compatibility fix for;

• You must be registered for see links
  add-on
• @Banxix's
  You must be registered for see links
  add-on

You must be registered for see links

 

[ven0m]

Resource updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Re-release v2.3.0 without debug code

You must be registered for see links

 

[ven0m]

Resource updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Shim reactions received lists (and reactions given if User Essentials is installed)
• Add various addon options into their own grouping

You must be registered for see links