ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 33,628
- Points
- 823
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:
Read more
Continue reading...
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...