Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
2648 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
2000 ms rule for Task Reports
mathieud
over 7 years ago
Any tips on how to improve performance of task reports? We seem to be hitting the 2000ms rule. We are worried that performance will get worst as we add more process models in the report.
OriginalPostID-241518
Discussion posts and replies are publicly visible
0
ChristineH
Certified Lead Developer
over 7 years ago
Here are a few quick things to look at:
1. Remove any columns that are not displayed or needed to do evaluation on
2. Remove any functions on columns that are not needed
3. Remove any aggregation that is not needed
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chris
over 7 years ago
Aside from the improvement suggestions that Christine posted above, you can also increase the report timeout via custom.properties - we've had ours at 10 seconds for a number of years now without issues other than wait time (user experience), but our users agree for heavy reports a slight wait is better than an error.
server.conf.processcommon.MAXIMUM_REPORT_MS=10000
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mathieud
over 7 years ago
Can you increase the limit when you are in the cloud?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chris
over 7 years ago
We are on-premise, I would have to defer to the Appian team on that question.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
In addition, is that using a!queryProcessAnalytics() or the old plugin? If it's the old plugin, it might be worth a try with the newer a!queryProcessAnalytics.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
tharshulas
over 7 years ago
Do you want to look up all the process models every time? if not, please consider passing process models/ ids dynamically during run time which will help to improve the performance by reducing look up/scanning time of instances
We had similar issue and started passing the process models (which are only necessary specific run) dynamically during run timein a!queryProcessAnalytics and helped us to improve the performance
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel