Long load time with large reports

Hi,

I've developed a report in BIRT that produces a long list. It will run for hours - after which I give up. The report uses data from an Oracle DB. The interesting thing is that I watched the network utilization and it was pulling the data down in drips - meaning the network util never rises above 1MBps. I've tried this using various versions of the oracle thin drivers and the results are the same.

The strange thing is that when I run the query in sqlplus or in Access w/ ODBC I get the data in about 2 minutes. Of course these other tools are using as much network as they can.

It seems to me therefore, that there is some limiting factor like a buffer, but I can't figure out exactly what it is.

Has anyone had a similar experience - low net utilization using oracle thin drivers - and do you know if I can tweak something to get better throughput?

Find more posts tagged with

Comments

rmurphy

You might try downloading the Actuate BIRT Designer Professional. It contains some DataDirect drivers that are more high performance than the standard Oracle thin drivers. 
 
A BIRT 2.2.2 version can be downloaded from: 
<a class='bbc_url' href='http://www.birt-exchange.com/downloads/birt-report-designers/238-actuate-birt-report-designer-professional-for-windows-release-9sp3/'>Actuate BIRT Report Designer Professional for Windows, Release 9SP3 - Downloads - BIRT Exchange</a> 
 
A BIRT 2.3 version can be downloaded from: 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/visit.php?lid=496&agree=true'>Business Intelligence Software - Reporting Tools - BIRT Exchange</a> 
 
Rob

sneufeld

Thanks rmurphy.

I downloaded BIRT 2.2.2 version and imported my report. The network utilization is pretty consistent at 1% which is better because using the Oracle drivers, it wasn't that consistent. I still thing it's too slow in getting the data to show the entire report.

Looking at the network utilization is seems as if BIRT is reading the data from the DB, buffering it, clearign the buffer and then repeating. Can I configure how large the buffer can be?

If I'm completely off track with that one...is there a different approach i should take? The data is about 15,000 records long and about 25 MB when exported to log using sqlplus.