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.