- XF Compatibility
- aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single
- Short Description
- You can FREE Download Optimized List Queries by Xon version V2.11.0 from nullpro website. it is zip Extention type and 27.3 KB File size. Until Optimized List Queries by Xon have 1 Description Attachments, 5 discussion, 5 Updates, 273 Views.
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:
Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.
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.