We are using camunda REST api to query for historic process instances, task instances and variable instances. Everytime we will query with process variables and we are facing slowness in query response timing.
Can we add index for ACT_HI_VARINST table with fields NAME_ and TEXT_ columns? (index for process varaibles)
But the TEXT_ column comes with 4000 bytes column size, creating index with 4k bytes column in mysql db will throw an exception becuase allowed column size for index in mysql was 3072 bytes.
If we reduce the column size of TEXT_ column would be a problem?