Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT Excel report generation for large data(BIRT Excel report generation using spudsoft excel emitter for large data)
BIRT Excel report generation for large data [message #1796162] Sun, 07 October 2018 15:54
Shagun Akarsh is currently offline Shagun AkarshFriend
Messages: 2
Registered: October 2018
Junior Member
I am using BIRT runtime 4.8.0 in a java project for generating Excel reports. The excel report has 1k columns and can have 10k to 50k rows (result of 1 query, maps to 1 table). I am using spudsoft ExcelEmitter for rendering the static excel reports.

Data source: Impala jdbc connection, using 1 dataset with 1 query

The issue is it takes 6 to 7GB of heap space (java) just to render 10k rows in this report, so as to load everything in memory and then write it to file.

Is there any way to reduce the memory footprints (predictable heap space usage preferably under 3GB) while rendering the excel sheets (options like pagination of query results, rendering file in parts, etc)?
Previous Topic:Page-wise Subtotal in Master_Page
Next Topic:Digital Signature and Adding Metadata to Birt Reports
Goto Forum:

Current Time: Tue Oct 22 19:40:35 GMT 2019

Powered by FUDForum. Page generated in 0.01514 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top