newimage submitted a new resource:
Optimized List Queries by Xon 2.4.0 - Optimized
Read more about this resource...
Optimized List Queries by Xon 2.4.0 - Optimized
Read more about this resource...
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.
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 threads implement...
Add option "Fetch all the nodes at once instead of per-type", for forums with a large enough node-count the per-row XenForo Finder overheads become unacceptable
Add support for Audentio's Feeds add-on, specifically the Thread Feeds
- Support conversation lists with large number of conversations (Requires SV/StandardLib v1.10+ for this feature)
Ask a question v1.8 changes:
Fixed issue with Enhanced search if using HTTPS index.
- Add support for @Bob's Review Management System