BIRT Performance

iswanto

Hi,

This is my first post.

I using BIRT 3.7.1, deployed in tomcat app server and connect to Oracle 11g db.
The problem is, the report has slow response even if i set BIRT_VIEWER_MAX_ROWS = 1.
For 1 rows, the report need 4 seconds to display the result.
For 3000 rows, it needs 30 minutes.

Can anyone help me what is wrong with my report ?
I set the log level = ALL and i attach it in this report.

Thanks!!

Tubal

Have you tried running your sql queries without the report? It looks like it may be your query.<br />
<br />
Here is 48 seconds right here:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>Feb 14, 2012 1:53:59 PM org.eclipse.birt.data.engine.impl.QueryResults close
FINER: QueryResults is closed
Feb 14, 2012 1:54:47 PM org.eclipse.birt.data.engine.impl.DataSetRuntime DataSetRuntime
FINER: ENTRY org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@186b480a null</pre>
<br />
And another 15 seconds:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>Feb 14, 2012 1:54:57 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINEST: ResultSet.getMetaData( )
Feb 14, 2012 1:55:12 PM org.eclipse.birt.data.engine.odaconsumer.PreparedStatement getRuntimeMetaData
FINER: RETURN org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSetMetaData@43822cd2</pre>
<br />
I don't speak BIRT, but it looks like it's waiting for query results to me.