External issue Forums Page very slow query

[DevPunk]

Affected version

2.3

Original Query
Runs over 8 sec



after run this:
`xf_forum` ADD INDEX(`find_new`);"


Now the query is no longer slow. Have you forgotten an index here or is something wrong with my DB?

 

[Xon]

How many forums do you have?

The find_new index isn't actually being used, which suggests it might have been a database statistics thing.

 

[DevPunk]

How many forums do you have?

3

 

[XF Bug Bot]

Automated triage: Server issue

Thank you for reporting this issue. The faster query plan after your change still joins forums by their primary key and doesn't use the new index. The speed-up most likely came from the table rebuild refreshing the database's statistics, not from a missing index, so this points to how the database server chose its plan.

This is an automated assessment. A member of staff may review and update it.