Resource icon

Optimized List Queries by Xon 2.9.0

No permission to download
Xenforo Version
  1. 2.2.x
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 implement paging.

This addon provides some optimized query for getting threads in a forum with large number of threads, or for conversations with a veryhigh page count.

Ideally conversations would implement the position system like posts do, which would be even faster than using sub-selects to force 'late row lookup'.

09202109_28.jpg

Contributing features or bug fixes
Please create a Github Pull request via the "More Information" li
Author
Wells
Downloads
0
Views
175
Extention type
zip
File size
33.2 KB
First release
Last update
Rating
0.00 star(s) 0 ratings

Link was Broken?

Please send message in Discussion, You will get it very quickly!

Support Developer

If you are satisfied with your test or project have earn money successfully, Maybe you can click more information button to support with buying.

More resources from Wells

Back
Top