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; } } }

Issue handling large script dataset in Birt

anees.shaik

Hi we are running into memory issue when we are trying to pull 700k records using scripted-dataset and same number of records are easily getting pulled using jdbc-dataset. Need help understanding how birt handles scripted dataset from jdbc dataset and how can scripted dataset be fine tuned to access huge record. Thanks

Find more posts tagged with

Comments

kclark

Is it locking up or are you getting any error messages?

anees.shaik

Yes, it is locking up and server memory is reaching 12 GB and Java heap hovers from 4 to 6 GB. Does BIRT uses any memory which is not part of the java HEAP ? Also It looks like the memory is not reclaimed. This was the only report runing on the server. We have checked the logs and it looks like the BIRT did generate the tmp files successfully. We did run another report with sql data source that had about the same number of records on the same server and it ran successfully. Here is our server stats:Available memory: 15 GBHeap: 12 GB

anees.shaik

Hi Clark.. Let me know if any further details required. Thanks

Yaytay

I've also had performance problems with large (100k rows) scripted data sets.
I got around it by moving to jdbc.

Something you could try is using a java event handler instead of javascript - I don't know whether that'll make any difference, but it does cut a chunk out of the processing.