It's all about the answers!

Ask a question

Query more than 1000 work items page by page


Chao Yang Guo (653) | asked Oct 17 '11, 4:03 a.m.
JAZZ DEVELOPER
Hi,
Customer need to retrieve all work items (more than 5 M items) in RTC to analysis in their BI system, like our Data warehouse.

But as we know, we limit the query item number to 1000 by default.

If we change this limit in "Advanced properties" page by changing "Maximum Query Result Set Size" number and restart server, what is the max size we should set and what is the performance impact to server?

If we set the max size to 5M (like 5,000,000), does it mean it will load 5M items into memory even I use the client side OSLC paging service (each page have 100 items)? Thanks!

Steven

One answer



permanent link
Ralph Schoon (61.4k33643) | answered Jan 13 '12, 8:22 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I would suggest to use the plain Java API to write a tool that gets all work items out. There you can change the limit.


IQueryResult<IResolvedResult<IWorkItem>> resolvedResults = queryClient.getResolvedQueryResults(queryToRun, IWorkItem.FULL_PROFILE);
resolvedResults.setLimit(Integer.MAX_VALUE-1); // First thing to do!!!!!!



Otherwise the limit is for all users. If the limit is set to 5M in the advanced properties a user could query 5M work items. He would load them paginated still.

Your answer


Register or to post your answer.