QueryExpired solution recommendation
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)
|
Be the first one to answer this question!
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
Or you have to up the query expiry time in CCM Advanced properties
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..