@baris creation of index for tid can help in this case? can it harm something?
what additional indexes would you suggest to add?

Latest posts made by Evg R
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@julian @PitaJ It looks like when I am logged in it selects additional not indexes tables. We need to improve, make faster queries of the newly added topics. Can you suggest more indexes exactly for logged in user?
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@julian When disabling the plugin and rebuild the Speed is the same. But day by day of just waiting it becomes quicker since the last creation day of topics
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@pitaj But when I log out the speed is quick as usual. Could it be related to the indexes with such a behavior?
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@pitaj I've just checked the indexes in db, and find out that nodebb db size is 0. So I forgot that I store all the data for nodebb forum in the different one db, and that db already had the indexes. So no changes were made to the db with nodebb forum
The reason of long load page time is still mystery but its related somehow to write-api plugin.
I need to use this plugin to post more topics but I need to fix something to avoid such bad situation with long load page time -
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
Today the page load time is about 5-10 secs for logged in user (previously it was more then 1min), so maybe some sessions are destroyed or something?
I kept write-api-plugin disabled and did not use it for 2 days
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
I've disabled all the plugins - CPU is becoming lower but I still have timeouts when log in and refresh (almost all the time > 1min, sometimes 58secs)
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@baris I've just tried with newly created user and it's the same situation - timeouts
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@pitaj The problem appeared after I installed nodebb-write-api plugin and post several tens of thousands topics, the more topics I posted the longer time for refreshing the page with logged in user
So I do not think other plugins rather then nodebb-write-api impact this issue
-
RE: Very long page loading time when refreshing and I am logged in by any user and quick loading when I am logged out
@baris The problem with 504 timeouts appears only when I try to login or refresh with logged in user. Maybe some cache for sessions should be cleared or something related to user data?