We noticed the the tracking state in the data-preloaded is extremely long particularly for trust level 3 or 4 or users who have been active for a long time.
Is deleting users’ topic tracking states from the db or alternatively removing or limiting it from the above queries going to do any damage? like taking away their badges or trust levels etc.
We encountered a similar issue where the query for the topic tracking state consumes approximately 70% of the homepage rendering time. Under high load conditions, this query can even take over 1000 ms to complete.
I think there should be an (optional) approach to make the topic tracking state an asynchronous request, thereby enabling users to view the homepage more swiftly.
exactly! I’ve seen up to 3000ms
