We have a query regarding k2 performance. The scenario in our project is that we expect around a million process instances( including Active, Completed) created in our system in PROD environment. And at a point we need to query the tasks which are being assigned to a specific user. For this we are relying on the K2 in built “ActivityInstanceDestination” smart object to do a query and find out the tasks that are assigned to a particular user. We did a sample check and found that for 30k process instances the query to get the tasks assigned to user ( using ActivityInstanceDestination smart object) is taking around 10sec. In PROD this will be degrade the performance more as we will have million process instances.
Do you have any inputs or suggestions to handle this particular case, why the ActivityInstanceDestination Smart object query performance is that slower. Is there any way to tweak its performance or is there any other way to get the tasks assigned to a particular user( both Active and completed ones).