Task query slow

[mahavirj]

I have a task query (below) that returns more than 4000 tasks and am getting the first 50 to be displayed back on screen.  This takes over 40 seconds in tomcat/sqlserver for a single user test. I've checked the query issued by activiti and it takes less than a second in sqlserver. jvm heap size is 1024m and should be adequate for this data.

taskService.createTaskQuery().processDefinitionKey("orders").taskName("review order").taskUnnassigned().list().subList(1,50);

Any clues on what could be going on?

[ronald_van_kuij]

Yes, you should limit it with normal paging aggording the query api. Now it build object models of all 4000 tasks and then takes a sublist from that.

[mahavirj]

thanks, using the listpage api worked much better

[ronald_van_kuij]

Great to hear. Thanks for the feedback.