nagasai Posted April 20, 2007 Share Posted April 20, 2007 Hello everyone, I am new to Jasper Reports(using 1.3.1). I am using MySql5.0 as Database. I have a table containing 100,000+ records and i want to show only 50 records per page and scroll with next and previous buttons like that. I tried using JRFileVirtualizer. The JR File Virtualization is sometimes taking more time than the one without using virtualization. For pagination and reports with hugh volume of records, will Virtualization is the solution or JRDataSource a solution or is there any other way using JDBC row sets. I found the CachedRowSet in rowset.jar, but that will consume very much memory. Can anyone help me out my problem... Any help is thankful.. ThanksNagasai A Link to comment Share on other sites More sharing options...
Teodor Danciu Posted April 20, 2007 Share Posted April 20, 2007 Hi, For large documents, virtualization is the only way. It takes care of minimizing the memory consumed to store the resulting document.Memory consumed by the data source is another issue and for JDBC data sources it would be the responsibility of the driver to fetch only limited amounts of data at a time. It is slower when you use virtualization, but let me put it this way to you: you either consume more memory or more time. It depends on what you want to spend: memory or time?With large documents, time should not be an issue, because nobody would expect a 100.000 records document to pop-up in a second. And even if it did, who would start to read it? It would take them hours just to browse it page by page. I hope this helps.Teodor Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now