Unfortunately, I'm very busy right now, but it seems like more people are having this problem. Maybe you could just pass on the information again. I really need to recreate all of this on the test server.
I received this email with interesting and useful observations.
He is back on 5.7.2 right now. Nevertheless, it might be interesting.
...
I have had the same problem with version 6 and finally I had to downgrade to version 5.7.2.
I have found out that the problem were producing dynamic content, more precisely when you have dynamic content index page which is on some dynamic text field linked to dynamic content detailed page.
...
the system would produce thousands of duplicate queries (in my case over 20 000) which consume all the recourses which caused page crashing or if it's not crashed I had the same situation in the backend (slow adding new articles or editing the existing ones - almost 60 sec and also changing category).
...
So I've backuped my site and tested locally. Problem witch beckend has not appear (peobably because of higher recourses on my local VM) but links on detailed pages were very slow and each click would be produce CPU usage going to 100%.
Finally I have found that the problem is in SEF URLs.
If I turn off SEF URLs that dynamic content links to detailed pages works very fast - just in sec or less.
So my conclusion is that Joomshaper maybe produce some bug in routing because I saw in the changelog of the version 6 that they have item: Fix: Fixed SEF multilingual page routing issues.
...
Hope this helps the team with bug fixing. Best regards