asked on

Report in SWING

Hello,

I am developing SWING app using jdk 1.4.2 and HSQLDB.

Well, it works fine now. However, in near future, the data in HSQLDB may grow up to 1 million records or even more. I am afraid that this may slow down or even *crash* the application in the future as I have one report feature where it displays out the data from one table in DB. This table is the table that contains more than 1 million records.

Now, I am thinking to use JFreeReport to display the report.

What would you think or suggestion?

Thanks
David

suprapto45

ASKER

I will have a look at this thread later on.

David

Mayank S

Yes, I guess you should move on to JFreeChart. I thought you werre already using it

suprapto45

ASKER

>>"Yes, I guess you should move on to JFreeChart. I thought you werre already using it"
Do you mean JFreeReport?

I am about to implement the JFreeReport. However, as far as I know, using JFreeReport, you need to populate the TableModel first then pass it to the report. Has JFreeReport been able to handle huge data as 1 million records? If so, what should I do to minimize the impact of the memory exhaustion of my application?

Or do you have any other alternatives instead of querying the DB for the entire 1 million records?

Thanks
David

Mayank S

Sorry, yes I meant JFreeReport.

>> Has JFreeReport been able to handle huge data as 1 million records?

Will check and let you know. are you thinking of implementing pagination?

suprapto45

ASKER

>>"Will check and let you know. are you thinking of implementing pagination?"
If in J2EE yes. That's why I am confused in J2SE. What do you people normally do to handle this kind of situation in J2SE? Do you use pagination or any other thing? I may not have known few technologies in J2SE as I always deal with J2EE.

This is my first project in SWING :).

David

ASKER CERTIFIED SOLUTION

Mayank S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mayank S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

suprapto45

ASKER

Thanks mayank,

I'll have a look at it later.

David

Mayank S

You needn't accept before trying....

suprapto45

ASKER

mayankeagle,

Sorry for any delay in replying.

Well, at this point of time, I really have not 100% sure to go ahead with any solution. I am still thinking the best way on this if it happens in the future. So any link / feedback would extremely be useful for me as I am still considering all the factors. Hence your suggestion and feedback are valid to be accepted.

Thanks again.
David

Mayank S

Ok, thanks.