Resource icon

[Free Add-on ] Optimized List Queries by Xon 1.3.5

No permission to download
  • Author XenForo Rocks
  • Creation date
    • You can download only 0 resources in 24 hours
    • You need more than 0 posts to download the resource
Compatible XF Versions
1.4, 1.5
MIT Licence
Visible Branding
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:
XenForo Rocks
First release
Last update
5.00 star(s) 1 ratings

More resources from XenForo Rocks

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
  4. 1.3.1 - Bugfix update

    Fix "Datas must be string or set automatic_serialization" due to failed serialization.
  5. Maintenance Update

    Tweak options (add min values where appropriate), change "Faster Members Online Query" default...

Latest reviews