Datamanager listing SQL query improvements
The listing view in Preside datamanager is backed by SQL queries that could be improved.
Areas of improvement:
1. refactor dynamic rule engine filter expressions
2. get rid of distinct
3. get paged recordset + total record count in one single query
For topic 1 there are individual tickets here:
Topic 3 is covered in
Getting rid of the distinct can be done within this ticket but is blocked by the others which need to be solved first (because those additional filters could introduce extra joins currently which would lead to duplicate records - after refactoring them this problem does not exist anymore).
If this is all done we will see a massive improvement in regards to query speed, especially on large volume tables or if more complex joins are done.