Limitation on query tasks with variables

[tonychou]

There is a limitation of 20000 for query tasks with variables in org.activiti.engine.impl.persistence.entity.TaskEntityManager

// setting max results, limit to 20000 results for performance reasons
    taskQuery.setMaxResults(20000);
    taskQuery.setFirstResult(0);

But, we need to query more that 20000 variables.. So, we have to override this class to be able to do our search, which is annoying

Isn't it better to implement this in the way which is configurable? So, user can choose the limitation by themselves.

[vasile_dirla]

Hi,
It's true that having it configurable it's more flexible for the developers using it.
(We'll be happy if you could create a PR for it.)

Out of curiosity, why do you need to have so many results, what you would like to do with these results?
Usually I prefer to add some more restrictions on the query in order to have a smaller number of results (a more relevant set).
(I guess you are keeping one eye on the performance statistics when you are working with so many results from a single query)