What's new

Welcome to NullScriptz - NulledScriptz

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Ask question

Ask Questions and Get Answers from Our Community

Answer

Answer Questions and Become an Expert on Your Topic

Requests

Can't find what you are looking for, request it in our request section our staff and members will do their best to help you!

  • Due to new payment rules, all accounts must have a 2-step verification.
Xon - Optimized List Queries

Xenforo 2.2.x Xon - Optimized List Queries 2.5.0

No permission to download
Compatible XF Versions
2.1.x, 2.2.x
Your advertisement here?
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 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:
Configuration
Under "Performance":
191038
Author
WinSys32
Downloads
0
Views
49
Extention type
zip
File size
20.9 KB
Hash
7799ee0c8e8395f4832b4ab0723ffb15
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from WinSys32

Similar resources
Resource starter Title Category Downloads Last update
WinSys32 Xenforo 2.2.x Xon - Redis Cache Xenforo 2.2.x Addons 0
WinSys32 Xenforo 2.2.x Xon - User Promotion On Profile Update Xenforo 2.2.x Addons 0
shape1
shape2
shape3
shape4
shape7
shape8
Top