Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Double Query execution in RunTask and RenderTask
Rainer
Hi all,<br />
<br />
I integrated ReportEngine in Web Application. After migrating to 2.5.2 I am using IProgressMonitor zu log status of report execution. Report execution is done by RunTask writing rptdocument and then RenderTask to render the output in the desired format. I checked the records that IProgressMonitor writes into the logfile and it seems that both RunTask and RenderTask execute all defined report Queries.<br />
<br />
This is the output I got from logfile. <br />
<br />
DEBUG 11:03:40,552 btpool0-7 - <span style='color: #FF0000'>Starting Run Task</span><br />
DEBUG 11:03:41,893 btpool0-7 - Starting Page: 1<br />
DEBUG 11:03:41,920 btpool0-7 - Starting Query for element Id: 250<br />
DEBUG 11:03:42,250 btpool0-7 - Ending Query for element Id: 250<br />
DEBUG 11:03:42,349 btpool0-7 - Starting Query for element Id: 570<br />
DEBUG 11:03:42,355 btpool0-7 - Ending Query for element Id: 570<br />
DEBUG 11:03:42,583 btpool0-7 - Starting Query for element Id: 322<br />
DEBUG 11:03:42,602 btpool0-7 - Ending Query for element Id: 322<br />
DEBUG 11:03:42,608 btpool0-7 - Ending Page: 1<br />
<br />
DEBUG 11:03:43,159 btpool0-7 - <span style='color: #FF0000'>StartingRender Task</span><br />
DEBUG 11:03:43,242 btpool0-7 - Starting Query for element Id: 250<br />
DEBUG 11:03:43,255 btpool0-7 - Ending Query for element Id: 250<br />
DEBUG 11:03:45,239 btpool0-7 - Starting Query for element Id: 570<br />
DEBUG 11:03:45,240 btpool0-7 - Ending Query for element Id: 570<br />
DEBUG 11:03:45,963 btpool0-7 - Starting Query for element Id: 322<br />
DEBUG 11:03:45,964 btpool0-7 - Ending Query for element Id: 322<br />
DEBUG 11:03:45,964 btpool0-7 - Ending Page: 1<br />
<br />
I thought rptdocument would contain data from query execution and further operations on database<br />
are not nessessary.<br />
Its only very little time that is spent in RenderTask because data in this case come<br />
from Query Cache but in my eyes redundant. Does RenderTask execute report Queries? and if so,<br />
is there way to avoid it?<br />
<br />
Regards Rainer
Find more posts tagged with
Comments
There are no comments yet