[Resolved] Generating report with subreports is very long

[shizuku]

Hi eveyone,

I'm coming here to have any help about the generation of a report. I have a main report (+- 200K lines) who is generated in less then 2 minutes by ireport, but, when I add subreports to this main, the generation become very very slow (more then 1 hour) and I don't know why. In Toad all my requests are very quick and it's the same when I try all my subreports separately. I'm using iReport 4.5.1

After a lot of hours with my friend Google to try different solutions, IDK what to do more to increase the generation.

I tried :

• Change de config file of ireport by changing J-Xms512m -J-Xmx1024m line (can't put more then 1024 or ireport doesn't want to start)
• Use a virtualizer in the tools of ireport
• Print When Detail Overflow is false on every subreport

A total generation for 5 or 10 minutes can be OK for me, but more not.

I was wondering if using sub dataset can be a solution to replace sub reports ? (Never used it before, looking for tutorials to see when and how to use them).

I hope someone will be able to help :)

[Scott Andersen]

Where is the subreport located?  Is it in the detail band?  If so, then the query for the subreport will be generated 200K times which may describe why the performance hit.

[shizuku]

He's located in a Group, but I find the solution : there was not an Index on a column I used in my where clause. Now the generation tooks a little more then 5 minutes :)

BTW thanks for the information, I'll keep it in mind in the future if needed