Hi all, My POST to /query/historic-process-instances restful endpoint is very slow with option includeProcessVariables=true. We have only 400 historical process instances. However I am relying on process variable to store some additional data on the process instance. Did I choose the wrong approac…

Hi, When process variables are included, an outer join is made with the ACT_RU_VARIABLE table. Is it possible that you have a large number of variables, or a couple of big variables store in the engine database? In this case the query can be really slow. Do you need the variables to be returned tog…

Hi Tijs, I have about 20 variables per instance and they are all small string. Just feel it should not be this slow to return a couple hundred results. I just want to store additional metadata like “category” on process instances, without creating my own database tables to correlate them. Process v…

Hi, Via the REST API also a count query is performed after fetching the results, so the query time is already doubled. Together with paging this could result in this response time, although it’s really a lot for just 20 variables. Which database are you using? I think the query in Flowable is just …

Hi, Can you please tell me how to set the log level to debug. I already changed the log4j.properties files in all unpacked folders of all the five applications but still not able to see any debug logs

I did restarted the tomcat. Here is the log4j.propeties that i changed. Please let me know if there is anything wrong in that[Capture1] . But i didn’t see any debug log after starting the tomcat server.

Very slow api call with includeProcessVariables

Flowable Engine

Robinyo January 28, 2019, 10:42pm 6

See: Generate log files

Topic		Replies	Views
Na variables in query endpoints but in historic-variable-instances endpoint Flowable Engine	3	118	September 18, 2025
Retrieve only defined set of variables in historic process instances Flowable Engine	1	519	December 4, 2019
Performance issue in querying active tasks Flowable Engine	5	1002	May 26, 2021
Query to get processinstance id from variable value takes around 5 minutes Uncategorized	3	789	July 9, 2021
REST: Task query:Get subset of process variables Flowable Engine	1	954	May 7, 2019

Very slow api call with includeProcessVariables

Related topics