[3.x] Discussion • cache flush ultra slow query - index optimization fix
Posté : 15 juil. 2024, 18:35
I've seen increasingly slow starts on 3.3.12 as the site grows. The issue is pretty simple, immediately after a cache flush, there are two queries that run:
Code:
SELECT ug.user_id, a.forum_id, r.auth_setting, r.auth_option_id, ao.auth_optionFROM phpbb_acl_groups a, phpbb_user_group ug, phpbb_groups g, phpbb_acl_roles_data...
En savoir plus...
Code:
SELECT ug.user_id, a.forum_id, r.auth_setting, r.auth_option_id, ao.auth_optionFROM phpbb_acl_groups a, phpbb_user_group ug, phpbb_groups g, phpbb_acl_roles_data...
En savoir plus...