Optimized List Queries by Xon

Optimized List Queries by Xon 2.11.0

No permission to download
Overview History Discussion
Shayan Xtreme

Shayan Xtreme

Well-known member
Trusted Uploader
Jun 4, 2022
316
298
70
Shayan Xtreme submitted a new resource:

Optimized List Queries by Xon - Optimized List Queries by Xon

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...
Click to expand...

Read more about this resource...
 
  • Like
Reactions: tanierlyons
You must log in or register to reply here.

Similar threads

Minion01
[OzzModz] List Soft Deleted Threads
Replies
0
Views
133
Add-ons [2.x]
Minion01
Minion01
emonk
[OzzModz] BB Code: Thread List Alphabetical
Replies
0
Views
262
Add-ons [2.x]
emonk
emonk
Radical
[XTR] Node List Widget
Replies
0
Views
356
Add-ons [2.x]
Radical
Radical
ELLIO7
[Xenbros] Node List Sidebar Widget
Replies
6
Views
1K
Add-ons [2.x]
Quick87
Quick87
DataMaster
Xenforo 2x All Add-ons List (Sorted by Rating)
Replies
18
Views
15K
Add-ons [2.x]
Megachad
Megachad

Latest posts

Forum statistics

Threads
69,206
Messages
908,349
Members
236,884
Latest member
Binotrada

Share this page

Share this page

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

Forums Contact us

User Menu

Login
Community platform by XenForo © 2010-2022 XenForo Ltd.
Top Bottom