Optimized List Queries by Xon

Optimized List Queries by Xon 2.12.0

No permission to download
XF Compatibility
  1. 2.2.x
Short Description
Download and Discuss Premium, BusinessOptimized List Queries by Xon 2.12.0 version on Premium Content Best Download Discussion Community. It is zip Extention type and 26.7 KB File size. From Optimized List Queries by Xon have 1 Description Attachments, 6 discussion, 6 Updates, 405 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.webp
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
405
Extention type
zip
File size
26.7 KB
First release
Last update
Ratings 0.00 star(s) 0 ratings
Link was Broken? Please  Send Message to NP Team with direct message, 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.

Latest updates

  1. 2.12.0 - changelog
    This addon is now available on https://atelieraphelion.com/ Require StandardLib v1.20.0+...
  2. V2.11.0 - V2.11.0
    Add support for @Bob's Review Management System
  3. 1.8 - 1.8
    Ask a question v1.8 changes: Fixed issue with Enhanced search if using HTTPS index.

More resources from newimage

VOX Android Online Radio N
Android Online Radio Application is app that listen live radio on android device.
Sitemap xml pro Module N
Very easy to use and create the correct site map.
Top