Anh chị em Việt Nam
COME AS GUESTS. STAY AS FAMILY.
Optimized List Queries by Xon

Optimized List Queries by Xon 2.2.2

No permission to download
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":
1545403033435-png.191038



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
dinhphucv
Downloads
8
Lượt xem
146
First release
Last update
Rating
0,00 star(s) 0 ratings

More resources from dinhphucv

Latest updates

  1. 2.2.2 - Bugfix update

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

    Trim non-required left-joins when generating the eager join inner query
  3. 2.1.1 - Maintenance update

    Improve how the 'node type' cache is extended to be more resilient.

About us

VietFriend community được xây dựng với mục đích kết nối mọi người lại với nhau, là nơi để giao lưu, học hỏi và chia sẻ mọi thứ trên đời.
Top