I have a forum with many large threads (16k+ posts). After installing 2.3.0.beta10 +14 , I notice a severe slowdown in large threads. The following actions take multiple seconds now: Entering thread Jumping inside thread Scrolling inside thread When any of these requests is running, the correspond…

Hi Daniel, this problems should be expected with megatopics, see The MEGATOPIC: public good, or public menace? We recommend instead that you make more topics linked to each other instead of just gigantic one.

I realize big topics are discouraged. Still, I strongly disagree. Since this is a regression, it is not to be expected. Also, because there is no direct relation between post count and response time, something else is the deciding factor, like maybe different users in a thread. On a forum with more …

Is it possible there was a regression here @tgxworld ?

I have, anecdotally, noticed that the larger threads in my forum seem to be loading slower recently. For a bit a couple weeks ago it was quite rough @ 2s to load a 2K post topic, but it’s settled down to around 1s now. I assumed this was isolated to my installation (picked up a bad neighbor in Digi…

[صورة] Yuun: loading a larger topic as a guest or regular user is significantly faster than on my current (admin) account. [صورة] fuzzyk: Regular users are unaffected by this issue. Moderators and administrators are affected. cc @sam @tgxworld make sure you note this part

UPDATE I just found what could be the root cause of the slowdown, the new reviewable system is not windowing. We will get it sorted. Can you confirm that mega topics are fine if you are anonymous?

Anonymous mode appears to work fine on my end, nice snappy topic loads.

Until the following query, everything is fine: SELECT "reviewables".* FROM "reviewables" WHERE "reviewables"."target_type" = 'Post' AND "reviewables"."target_id" IN (<all the post ids>) The query itself is fast, too (Reader: 19.6 ms), if I understand correctly. Firefox is close to crashing from di…

Sorry about this, I will get it fixed today!

تباطؤ كبير للموظفين في المواضيع الكبيرة

الدعم

sam (Sam Saffron) 3 يونيو 2019، 5:27ص 8

Can you run mini profiler? You will need to be a developer for that per: Description of various user states in Discourse

What queries are running slow?

الموضوع		الردود	مرات العرض
Slow topic open when viewing as staff? Support	5	871	8 يونيو 2019
Improving Instance Performance (Megatopics, Database Size and Extreme Load) Self-hosting	60	5151	13 أكتوبر 2020
Performance improvements on long topics? Support	30	5560	20 أغسطس 2018
Topics load slow or not at all when they have many replies and user has bookmark in them Bug	6	1008	27 أكتوبر 2020
Bookmarking a Post on a Large Topic creates Absurd Loading Times Bug	10	1084	26 أكتوبر 2020

تباطؤ كبير للموظفين في المواضيع الكبيرة

الموضوعات ذات الصلة