xF1 Add-on - Optimized List Queries by Xon | NulledTeam UnderGround | The Best Scripts Site In The World
  • 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

Resource icon

xF1 Add-on Optimized List Queries by Xon 1.3.5

No permission to download
Compatible XF Versions 1.x
1.4, 1.5
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.

Node List Caching:


As the number of forum nodes grow, the front page will take longer to compute the node tree for rendering. This allows caching of the node list for members/guests for either just the root-node or any node with sub-nodes.

Members Online list:

This add-on introduces a faster 'members online' list designed to scale well to thousands of users online. However, this will not show users who are not staff or not followed in the list.

This lost of functionality may be undesirable so can be configured under the Performance options configuration.

Note; converting the xf_session_activity table from MEMORY to InnoDB is likely a good idea if you want to use the Members Online query tuning. As MEMORY table has MyISAM locking behaviour, and this causes lock escalations when joins touch the a MEMORY table.

Forum/conversation/Likes Received 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 is how likes, 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 very high 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'.

Configuration
Under "Performance":
Author
AnimeHaxor
Downloads
16
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from AnimeHaxor

Share this resource

Latest updates

  1. 1.3.5 - Maintenance release

    Improve the global RSS feature when selecting threads from a forum with a large number of...
  2. 1.3.4 - Maintenance release

    When an error occurs and the unoptimized conversation list query is run, call the right function.
  3. Bugfix update

    Fix error on search which can occur when limited to no add-on's are installed.

Dear User!

We found that you are blocking the display of ads on our site.

It looks like you're using an ad blocker. That's okay. Who doesn't?

But without advertising-income, we can't keep making this site awesome.

Thank you for understanding!