Jump to content
Changes to the Jaspersoft community edition download ×

JasperFillManager.fillReport() taking time


mitra4umohit

Recommended Posts

Hi

 

I am new jasper report.

I have started working in in Jasper just few week back.

 

In our project we need to generate report for nearly 80K rows at a stretch.

Few detail about project

App Server : JBoss 4.0

DB server : MySQL

Japser Version : 1.2

 

In order to address such huge data report generation I have taken few steps as follows

 

Using custom datasource instead of using JRDatasource which takes resultset as input and keep calling mysql once after each resultset fetchsize limit.

By using custom datasource i m passing pre-populated 80K rows data in form of arraylist to datasource.to avoid more database hits.

I am passing this data source in

JasperFillManager.fillReport(report, params, dataSource);

At 2nd step to handle such huge data i am using

JRFileVirtualizer to speed up report generation.

 

After doing all this to support huge data its taking almost 2hrs to generate report and which almost double than session time which we should not increase .:(

 

I was digging through my code as well as jasper source to find out which api exactly taking so long time, I found that fillDetail() most of the time.

fillReport() is taking almost 1hrs 45mins out of 2hrs

:ohmy:

 

As I know Japer is being used for many huge data report generation.So am i missing something in using Jasper report in optimal way.

 

Please give me your suggestion on how can I make such huge data report generation more optimal and faster.

 

Let me know your experiacne if at all some time anybody come across such situation and what steps did

he/she followed to get optimal solutions.

Early reply is highly appriceated

 

Mohit.:huh:

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...