Kindly help
When I call "OpenWorklist" function to get tasks from k2 databases the k2 engine generate script for this and it work fine for some user and get time out for another
I run sql profiler to track this execution and I found this issue in that script
This query case the problem of inbox when user delegates other users.
When try to measure execution plan of query I found that it create temp table and insert data on it and then execute 4 delete statements.
First, one take approximately 97% of execution plan.
I attach the script.
Regards