Also tested with the query from 2.1.8 (most recent)
DCG version:
2.1.5
Issue description
I have a MetaModel with a couple attributes of different kinds.
German is fallback and active language
There are around 2k rows.
The back-end list only shows title and subtitle which are both translatedtext attributes.
The back-end list is sorted by title ascending.
Showing only the first 30 items takes about 10s to load
Describe the behaviour of the application
The TranslatedReference::sortIds method is called three times on page load running the same query three times. It takes about 3.3s each. This is about 99.21% of total query time according to the Symfony profiler (Removing the sorting all together reduces the total query time to <100ms).
NOTE: This query is from 2.1.5, but I also run the query with the fixes merged by @stefanheimes in https://github.com/MetaModels/core/pull/1339 manually. It does not change the outcome.
My environment is:
Issue description
Describe the behaviour of the application
The TranslatedReference::sortIds method is called three times on page load running the same query three times. It takes about 3.3s each. This is about 99.21% of total query time according to the Symfony profiler (Removing the sorting all together reduces the total query time to <100ms).
This is the query with PR 1339 applied:
Further findings:
Stack traces