Плагин [Xon] Optimized List Queries by Xon v2.11.0

[InoryS]

InoryS добавил(а) новый ресурс:

Optimized List Queries by Xon - Набор запросов на замену для получения списков материалов, предназначенных для крупных форумов

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 threads...

Узнать больше об этом ресурсе...

 

[InoryS]

InoryS обновил(а) ресурс [Xon] Optimized List Queries by Xon новой записью:

[Xon] Optimized List Queries by Xon 2.11.0

• Add support for @Bob's Review Management System

Узнать больше об этом обновлении...