Welcome to Our Community

Registration on our forums are now open for some days! Feel free to sign up today.

Optimized List Queries by Xon 1.2.3b

A collection of replacement queries for getting lists of stuff aimed at large forums.

  1. XenForo Rocks
    Compatible XF Versions:
    • 1.4
    • 1.5
    License:
    MIT Licence
    Visible Branding:
    No
    This addon is aimed at large forum with potentially tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this addon.

    MySQL implements 'early row lookup' which 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 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'.

    For more information see: