[3.x] Discussion • cache flush ultra slow query - index optimization fix

[MagicFeedBot]

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