Bug Large Article forum being extremely slow

There is a bug in this version
I

ivp

Guest
Opening Article forum having Preview display style consisting of around 50,000 articles is painfully slow.

If change Display style from Preview to Standard, it opens instantly.

Had to change "Thread list date limit" to 1 year to speed it up. So instead of 1636, pagination shows 16 pages.

Here is the slow query (8 seconds):
Code:

SELECT `xf_thread`.*, `xf_deletion_log_DeletionLog_1`.*, `xf_user_User_2`.*, `xf_user_LastPoster_3`.*, `xf_thread_read_Read_4`.*...

Read more

Continue reading...