Optimized List Queries by Xon

Optimized List Queries by Xon 2.12.0

No permission to download
XF Compatibility
  1. 2.2.x
Headline
aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single
Short Description
Download and Discuss Premium, BusinessOptimized List Queries by Xon 2.12.0 version on NullPro 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, 387 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
387
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 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.

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

Proxmox VE VPS For WHMCS N
Proxmox VE VPS For WHMCS 3.8.1 (7.4+8.1) Untouch Version
a high-powered module that will automate all stages of provisioning virtual servers
Redis Cache By Xon N
This add-on uses Credis with a custom cache provider for Redis.
Top