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.

Your pinned fields
Click on the next to a field label to start pinning.




Jan Jannek