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