nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT Performance

mas_h

Hi, 
 
I'm using BIRT in my java application with Oracle 11g Enterprise Edition. 
While investigating the application performance, I come across the following in the log file: 
 
[2/9/11 12:48:00:416 CET] 0000007d DataEngineImp I Data Engine starts up 
[2/9/11 12:48:00:479 CET] 0000007d odaconsumer I org.eclipse.birt.data.engine.odaconsumer.ConnectionManager addProfileProviderService( Map ) Added default property service: org.eclipse.datatools.connectivity.oda.profile.connectionPropertyService 
[2/9/11 12:48:10:077 CET] 0000007d I sun.reflect.GeneratedMethodAccessor462 invoke SQL: [SQL QUERY ........] 
 
The question is, why we have 10 seconds gap between ConnectionManager and SQL execution? 
Does it have any backend processes during this time? 
Can anybody help to explain this? 
Thanks!

Find more posts tagged with

Comments

mwilliams

Is this the first report you've run? If so, it could be the OSGi startup. Try running it two consecutive times or run this report after running a different report.

mas_h

It looks like the gap is always there whenever I run the report no matter whether it is the first time or not.

mwilliams

Hmmm. Maybe it's taking that long to establish the connection before it can invoke the SQL query. If you make a report with the sample database and do this same logging, does it take the same amount of time?