Welcome to My iptv forum

  • Everyone is invited! My iptv forum is for everyone, new and advanced user alike!
  • Searching is key! Before you post a question, use the forum search feature to determine whether your topic has already been covered.
  • Do not start flame wars! If someone has engaged in behavior that is detrimental to the discussion -- spamming, harassment, etc -- report the post and we'll take a look.
  • Resource icon

    xF2 Add-on Optimized List Queries by Xon 2.11.0 2.11.0

    xF2 Add-on
    < Previous | Next >
    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.
    • Like
    Reactions: ByEfexor

    Latest updates

    1. Optimized List Queries by Xon 2.11.0

      Add support for @bob's Review Management System
    2. 2.9.0 - Feature update

      Add support for Audentio's Feeds add-on, specifically the Thread Feeds
    3. 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
    Views
    1,080
    Downloads
    0
    Updated
    0.00 star(s) 0 ratings
    Views
    855
    Downloads
    1
    Updated
    0.00 star(s) 0 ratings
    Views
    777
    Downloads
    0
    Updated
    0.00 star(s) 0 ratings
    Views
    289
    Downloads
    0
    Updated
    18,301Threads
    63,982Messages
    62,834Members
    superwuppie2Latest member
    Top