L3 - Default AT
- given
- engine running against PostgreSQL
- 250000 HAI records
- when
- i run query against /engine-rest/engine/default/history/activity-instance
- and sort by startTime
- and finished=true
- and firstResult=10
- and maxResults=1000
- then
- engine performs query faster then in 1 second
Hint
see http://stackoverflow.com/questions/11250253/postgresql-countdistinct-very-slow
Right now we would perform count distinct in order to perform pagination, which should work much faster in order to perform effective import into Optimize.