task query perfomance with variables

[whdwsl]

hi, guys,  when querying task with variables, it`s some a little slow.there is a table named ACT_RU_VARIABLE  with key-value structure, value can not be indexed,  is there a better solution?

[jbarrez]

yes, it can be a little slow, depending on the number of process variables.
Which query are you executing that you are finding to be slow?

[whdwsl]

ok