AnsweredAssumed Answered

Task query slow

Question asked by mahavirj on Jul 28, 2011
Latest reply on Jul 28, 2011 by ronald.van.kuijk
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?