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.
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!


One answer

permanent link
Ralph Schoon (63.2k33646) | answered Jan 13 '12, 8:22 a.m.
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.

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.