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?

Share your content here:

Don't want to upload to our server on NullScriptz, Then share it now on our partner shareupld.com! Upload for free or take a subscription to be sure your files are save !

Need hosting without problems?

We are offering our own hosting service now! Check it out and host your nulled website now without problems ! NullScriptz Hosting, we also offer Xenforo Hosting!

Knowledge Base

We are building our knowledge-base, find your answers! Or get directly in contact with us by creating a ticket. (In progress..)

Xon - Optimized List Queries

Xenforo 2.2.x Xon - Optimized List Queries 2.5.0

No permission to downloadVIP Upgrades
Compatible XF Versions
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
106
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

Xon - Redis Cache WinSys32
5.00 star(s) 1 ratings
Downloads
0
Updated
0.00 star(s) 0 ratings
Downloads
0
Updated
Andy - Bookmark List WinSys32
0.00 star(s) 0 ratings
Downloads
0
Updated
Andy - Forum List Count WinSys32
0.00 star(s) 0 ratings
Downloads
0
Updated
Top Bottom