+13
Sometimes need to run a report that filters with:
- specific process
- specific activity
- date range
- Action = Approve
Report to list the destination user that approved.
serverlog.actinstdest table has 11,457,455 rows.
serverlog.procinst has 657,772 rows.
I get timed outs using ActivityInstanceDestination SmO. K2 5.2 FP27.
Direct query in SQL server table via joins is fast.
How have you guys tackled this issue?
Good day
Because of this high volume of dataSet "serverlog.actinstdest table has 11,457,455 rows.
serverlog.procinst has 657,772 rows." Could you please install latest CU,
NB:- I recomment you follow this kb(http://help.k2.com/kb003190)
get it in this link https://portal.k2.com/products/k25-2may2019cumulativeupdate or https://portal.k2.com/products/k25-2may2019cu-fp1
I believe this should improve the performance as the was fix included, should you find tthis post useful kindly mark such as Kudu and/or Solution, to assist other community members absorbing relevant content on researches.
Thanks & regards;
Widson.
+13
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.