Guest viewing is limited
    • You MUST read  Myiptvforum Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.
    • The ONLY language allowed in this forum is ENGLISH and it should be used in ALL POSTS.

    • If you use a proxy server or a VPN for registration or login, your account could be directly banned. The reason is that you may register or login via an IP address that was used by a Members which was banned in the past. The same applies if different users use one device (PC, laptop, smartphone), this will also leads to a ban!
    • If you are banned for using a VPN Contact us by open ticket
    • All new Registrations will be manually approved Please do not use VPN or you will automatically get banned!
Resource icon

xF2 Add-on Optimized List Queries by Xon 2.9.0 2.9.0

xF2 Add-on
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.

Member List/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":
optimized-list-queries.png

Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.

Latest updates

  1. 2.9.0 - Feature update

    Add support for Audentio's Feeds add-on, specifically the Thread Feeds
  2. 1.8.0 - Maintenance update (with breaking changes)

    Update getEarlyJoinThreshold signature to be consistent, which is a backwards compatibility...

Similar resources

0.00 star(s) 0 ratings
Downloads
1
Updated
0.00 star(s) 0 ratings
Downloads
0
Updated
0.00 star(s) 0 ratings
Downloads
0
Updated
0.00 star(s) 0 ratings
Downloads
0
Updated
0.00 star(s) 0 ratings
Downloads
0
Updated
Top