- Katılım
- 23 Eki 2022
- Mesajlar
- 3,515
- Çözümler
- 9
- Tepkime puanı
- 2,145
- Puanları
- 113
- Yaş
- 28
Compatible XF 2.x
versions 2.1 2.2 2.3
Additional requirementsphp 7.2+
Standard Library by Xon v1.20.0+LicenseMIT LicenceVisible brandingNo
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:
Under "Performance":
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.
versions 2.1 2.2 2.3
Additional requirementsphp 7.2+
Standard Library by Xon v1.20.0+LicenseMIT LicenceVisible brandingNo
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:
-
Ziyaretçiler için gizlenmiş Kayıt olun Giriş yap veya üye ol.
-
Ziyaretçiler için gizlenmiş Kayıt olun Giriş yap veya üye ol.
Under "Performance":
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.
İçeriği görüntülemek için Giriş yapın veya Kayıt olun.
- Meta Title
- Optimized List Queries by Xon 2.12.0 – XenForo Liste Sorguları ve Performans Eklentisi
- Meta Description
- Optimized List Queries by Xon 2.12.0, XenForo forumunuzdaki liste sorgularını optimize eder ve sayfa yükleme sürelerini kısaltır. Forum performansını artırır, büyük veri tabanlarında hızlı listeleme sağlar ve kullanıcı deneyimini iyileştirir.
