We have an Adapt AT server where one course suddenly became quite slow to work with.
It is a 0.8.1/2.4.0 server with only 2 users and 4 courses.
Looking in the browser console it seemed that it was database requests when opening a page that would take around 10 secs.
It seems to be queries of this type: http://x.x.x.x/api/content/config/5c94cb234345070789fc9de7
Almost always config stuff (and typically a TTFB of 10 secs and a download time of a few hundred msecs).
I tried to look in the database collections but they seemed ok.
The "sessions" table did contain more that 83.000 records, which is far more than any other AT server we have, so I tried deleting the content of the "sessions" table, but it had no effect.
The 3 other courses on the server does not have that problem.
Neither of them are quite as big though.
The problem course has 11 main pages - 9 of which has 3-4 sub-pages, which in turn has 1-4 articles with 2-3 blocks.
We have had courses of similar size without any problems (though they were on 0.4.1/2.2.5 servers).
I also tried exporting the course and import it on a fresh AT server, but the problem was still there.
Lastly I tried making a copy of the server, and start deleting pages.
The response time seemed to drop linearly with the number of pages, but it seems that the response time with half the pages deleted, still is quite longer that the response time before the problem began, where at least 3/4 of the pages where implemented.
Has anyone any experience with this?