Overview Version (0) Discussion (2) License

• 

  Optimized List Queries by Xon

  This add-on is aimed at large forum with tens of thousands to hundreds of thousands or more threads

  forum

  optimized

  optimized list queries
  About this resource

  This add-on 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/Reactions/XFMG lists:
  
  MySQL/MariaDB 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/MariaDB 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 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:
  

  • http://stackoverflow.com/questions/4481388/why-does-mysql-higher-limit-offset-slow-the-query-down
  • http://explainextended.com/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/

  Configuration
  Under "Performance":
  

  
• Version

  There are no downloadable versions available for this resource yet.
• Discussion

  This resource has a discussion thread on the forum where you can ask questions, report issues, and talk with the author and other users.

  Join the discussion (2)

• License Terms
  
  By purchasing this resource, you are granted a license to use it on one (1) site, for as long as your license remains valid. You are not purchasing ownership of the underlying code.
  
  How your license works
  

  • Your license is checked automatically in the background. This never affects your site's visitors.
  • As long as your license is valid, this resource keeps working normally — even if our license server is briefly unreachable, a temporary network issue will never disable it.
  • Your license is bound to your site's domain the first time it's used.

  
  Moving to a new domain?
  Contact us and we'll move your license for you.
  
  What's included
  Updates and support for the period stated on this resource's page (see the Version tab for the current release).
  
  What's not allowed
  

  • Sharing your license with others, or using it on more than one site at a time
  • Removing or bypassing the license check in the code