Optimized List Queries by Xon

Optimized List Queries by Xon V2.11.0

No permission to download
XF Compatibility
  1. 2.1.x
  2. 2.2.x
Headline
aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single
Short Description
FREE Download Premium and Nulled Optimized List Queries by Xon V2.11.0 version from NullPro Community. It is zip Extention type and 27.3 KB File size. From Optimized List Queries by Xon have 1 Description Attachments, 5 discussion, 5 Updates, 347 Views.
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.
1604830414662.png

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'.

For more information see:
Configuration
Under "Performance":
Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.

Contributions

If you appreciate this add-on, please consider a contribution via PayPal. Details will be provide via private conversation.

Please contact me if you wish for different licencing arrangements.
  • Like
Reactions: Bxdguy
Author
newimage
Views
347
Extention type
zip
File size
27.3 KB
First release
Last update
Rating
0.00 star(s) 0 ratings
Link was Broken? Please  Send Message to NP Team with Ticket, 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 newimage

Latest updates

V2.11.0 - V2.11.0
Add support for @Bob's Review Management System
1.8 - 1.8
Ask a question v1.8 changes: Fixed issue with Enhanced search if using HTTPS index.
2.10.0 - 2.10.0
Support conversation lists with large number of conversations (Requires SV/StandardLib v1.10+...
2.9.0 - 2.9.0 - Feature update
Add support for Audentio's Feeds add-on, specifically the Thread Feeds
2.6.1 - 2.6.1 - Add feature flag
Add option "Fetch all the nodes at once instead of per-type", for forums with a large enough...

Similar resources

[0815] FileChk whitelist J
Whitelist for the XF FileCheck
0.00 star(s) 0 ratings
Views
196
Updated
[Andrew] Banned Users List N
provides a basic list off banned users with the following columns
0.00 star(s) 0 ratings
Views
541
Updated
[AndyB] Forum list count J
Shows number of forum list views by visitor type.
0.00 star(s) 0 ratings
Views
249
Updated
Back
Top