Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

QueryExpired solution recommendation

Questions
Tags
Users
Badges
sam detweiler
(12.5k●6●195●201) edited
Jan 17 '14, 4:40 p.m.
 a number of us have run up against the dreaded query expired problem

https://jazz.net/library/article/920

another recommendation not listed in the referenced article is to cache the data in the client pgm.

we have an app that is taking upwards of 30 minutes to go thru all the workitems in the query. (6700)
by changing the app to cache, the query elapsed time was reduced to 32 seconds.(getting one record at a time)
using the getPage() function the cache time dropped to 12 seconds. 

our app still takes 30 minutes to process. 

side question.. is there an explicit way to 'close' the query, rather than let it timeout?
(Set the result set object to null which 'should' force a discard)

0 votes

Comments
sam detweiler
Jan 17 '14, 3:11 p.m.

Or you have to up the query expiry time in CCM Advanced properties 



sam detweiler
Feb 20 '14, 6:48 a.m.

we kept running into long timeout issues..

I changed the code to cache all the query results at the beginning of the program,
then work off the cache.. takes a little more memory..

time to cache 7500 workitems.. 12 seconds..

0 answers
3,499 views
0 votes

Be the first one to answer this question!

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,950

Question asked: Jan 17 '14, 2:52 p.m.

Question was seen: 3,499 times

Last updated: Feb 20 '14, 6:48 a.m.

Confirmation Cancel Confirm