xF2 Add-on - Optimized List Queries by Xon | NulledTeam UnderGround | The Best Scripts Site In The World
Optimized List Queries by Xon

xF2 Add-on Optimized List Queries by Xon 2.2.4

No permission to download
  • Read Our Rules

    Dont forget read our rules Nulled Team UnderGround Rules

  • You may not say thanks or replied bad language in a thread - Your reply will be removed and warning! You must be like us "overview" in the resource. You will be access to download in FREE SECTION ONLY! DO NOT PREMIUM SECTION! Is only upgrade to up account.
  • Please support our site and click on the advertised
  • Complete Installation Service

    Review Our XenForo Complete Installation Service
  • Multiple Accounts

    Dont forget we not allowed Multiple Accounts, so all of your accounts as well as your IP will ban

Compatible XF Versions 2.x
2.0, 2.1
Additional Requirements
php 5.6+
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.

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.
Author
Admin
Downloads
12
Views
180
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from Admin

Share this resource

Latest updates

  1. 2.2.4 - Compatibility fix

    Compatibility fix for; Multi Prefix add-on @Banxix's [Banxix] Bump Thread add-on
  2. 2.2.3 - Bugfix update

    Fix 'show older items' in news feed would not return as expected
  3. 2.2.2 - Bugfix update

    Fix XF2.1 compatibility issue when viewing recent activity news-feed as a user who is following...

AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock