Navigation section

themka

XF 2 Optimized List Queries by Xon 2.6.1

No permission to download

WGOD!

The general member portfolio consists of software developers, company owners and investors. Our mission is to ensure that all shared content is clean and functional. For this reason, unfortunately, not every member is accepted. Please do not attempt to register for 1 software or 1 theme, membership is paid. You can join our telegram group below or send an e-mail to [email protected] to purchase the invite code for 10$.

Join Telegram
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:
Configuration
Under "Performance":

1615823166805.png


Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.

Contributions

If you appreciate this add-on, please consider a contribution via PayPal. Details will be provide via private conversation.

Please contact me if you wish for different licencing arrangements.
Author
themka
Downloads
0
Views
186
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from themka

Guest
Help Users
Our new point system :

https://www.wgod.co/threads/new-point-system-and-new-members-rule.21345/
  • No one is chatting at the moment.
  • aLeech:
    Guest Spaso has joined the room.
  • (Guest) Spaso:
    Hello
    Quote
  • aLeech:
    Guest babaniz has joined the room.
  • (Guest) babaniz:
    sa laannn
    Quote
  • (Guest) babaniz:
    SES VERİN GÖTLER
    Quote
  • aLeech:
    Guest hello has joined the room.
  • (Guest) hello:
    hello
    Quote
  • (Guest) hello:
    Import/Export PRO - The most complete importer for Opencart have someone have nulled?
    Quote
  • aLeech:
    Guest darbelimatak has joined the room.
  • (Guest) darbelimatak:
    sa
    Quote
  • (Guest) darbelimatak:
    benim hesabım vardı ama girilmiyo şifremi unuttum yapıyom mailde gelmiyo
    Quote
  • aLeech:
    Guest steliyan has joined the room.
  • (Guest) steliyan:
    Hello
    Quote
  • (Guest) steliyan:
    Anybody here?
    Quote
    (Guest) steliyan: Anybody here?
    Top