Hi,
My forum is quite big indeed but here is one slow query (in the log of mysql) that comes a few times :
(mysql 8 and the last version of the forum)
# Time: 2024-02-18T10:46:29.305623Z
# User@Host: XXXXXX[XXXXXXXXXXXX] @ [10.27.40.99] Id: 73771
# Query_time: 1.176123 Lock_time: 0.000002 Rows_sent: 15 Rows_examined: 115424
SET timestamp=1708253188;
/*XXXXXX::av_XXXXXXXXXXXX::IPS\Content\Search\Mysql\_Query::search:253*/ SELECT main.* FROM `core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND index_author=3539 AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY index_date_created DESC LIMIT 0,15;
# Time: 2024-02-18T05:04:42.734549Z
# User@Host: XXXXXX[XXXXXX] @ [10.27.40.99] Id: 50251
# Query_time: 1.796573 Lock_time: 0.000001 Rows_sent: 15 Rows_examined: 192661
SET timestamp=1708232680;
/*XXXXXX::XXXXXX::IPS\Content\Search\Mysql\_Query::search:253*/ SELECT main.* FROM `core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) AND index_author=3804 AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY index_date_created DESC LIMIT 0,15;
Thanks for your help !
Regards,