• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
  • Upgrade Your Account
    Hello Guest! Upgrade your account to download all VIP Resource here

Add-ons [2.x] Optimized List Queries by Xon 2.0.3

No permission to download

kuteboy

Ahihi
Staff member
Joined
Dec 13, 2015
Messages
923
Chủ thớt
#1
kuteboy đã đăng tài nguyên mới:

Optimized List Queries by Xon - A collection of replacement queries for getting lists of stuff aimed at large forums.

This addon 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 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 will fix this. Maybe.

This causes an issue as this how conversations and...
Đọc thêm về tài nguyên này...
 

Facebook Comment

Similar threads

New posts New resources Most viewed threads Threads with more replies