Performance drilldown & analysis for Report JDBC connection

legolas

Am trying to analyze the performance of a report generated using run servlet, while connecting to oracle database to fetch the data.<br />
<br />
We observed performance degradation of the report, when we run our report on a clustered environment on some of the instances. When the request hits a different box on the cluster, the performance is good. <br />
<br />
In the attached log, is the list of actions performed by the rpt and the time taken by each of them.<br />
<br />
On analyzing the report attached, we observed that there is a spike from line 194 and 206. There is a <strong class='bbc'>40 second delay</strong> that we saw when the db query is <strong class='bbc'>"SELECT ? FROM DUAL"</strong> which <strong class='bbc'><em class='bbc'>we are not performing from our end.</em></strong><br />
<br />
Is this added by default by the run servlet of the birt engine ??

legolas

Can someone confirm if "SELECT ? FROM DUAL" is fired by the BIRT engine to ensure the database connection is available ?