Increasing query result limit in JRS...what is the impact to server resources
By default JRS limits the number of query results of a report to 3000 items. This can be changed by changing the property value as described in this thread
The question is...As someone increases this number, What is an approach to identify a reasonable upper limit? Does increasing this number increase the RAM/CPU consumption of JRS or is it just a Usability constraint of how much can fit into the browser cache? We are looking for some guidance on what is impacted by increasing this number to 10,000 and beyond. p.s. The user scenario for this is trying to run a query that shows all defects in a large project area, then exporting it to excel for analytics. The report that returns these 10,000 records will not be for a human to read. It will be something for an analytics tool (like excel) to crunch. |
One answer
Ed, You need to consider what the limit is used to enforce. We have it smaller as a default for the majority of the use cases where JRS reports are used in dashboards. There it is expected that you're creating reports that can provide useful information at a glance. It isn't usual to want a dashboard report that returns thousands and thousands of results.
Comments Ernest,
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Yes, we're looking at the Watson Analytics integration and have some of the same questions.