honeybakliwal Posted January 28, 2013 Share Posted January 28, 2013 I have a report which takes around half an hour to generate a report. Please suggest some solution, In the report I have 95 fields with 25 variables and one scriplet and no subreport. The report has one group also . attaching the ireportpro.conf file details default_options="-J-Xms256m -J-Xmx2048m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=512m" Attaching the code of report also Link to comment Share on other sites More sharing options...
ayushkumar.bilala Posted January 28, 2013 Share Posted January 28, 2013 This might be the database related problem. Try running the query alone and see how much time query is taking, Link to comment Share on other sites More sharing options...
honeybakliwal Posted January 28, 2013 Author Share Posted January 28, 2013 The data is fetched easily with not so much time Link to comment Share on other sites More sharing options...
marianol Posted January 28, 2013 Share Posted January 28, 2013 How big is the result set of your query? How much is 'not so much time'? Link to comment Share on other sites More sharing options...
honeybakliwal Posted January 29, 2013 Author Share Posted January 29, 2013 It takes only 23 seconds to fetch around 1 lac of records. Link to comment Share on other sites More sharing options...
honeybakliwal Posted February 4, 2013 Author Share Posted February 4, 2013 Any luck on it 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