Using parameters in domains

[javier.ggi90]

Hi everyone, I am having some performance issues in my domain due to having a derived table with HUGE amounts of data. From what I have read and done I understand that a domain loads ALL the data in the database and then applies filters based on a report's parameters for example to filters all the retrieved data. So my question would be:

• Is there a way to load only information needed based on the parameters before the domain loads all the data from the database?
• If there is, how can I achieve this?

Thank you for your help,

Javier

[hozawa]

No. That's would actually decrease performance because domain are cached. Try pre-loading data or getting a faster database, or modifying JasperReports Server code to increase performance.

[javier.ggi90]

The problem is that, because of the way my application works and is used by clients, the domain's cache functionality was disabled. We are working on the database side now which is probably the best way to tackle this problem.

[hozawa]

Another solution is to just not use Domain - I've found domain to be a performance bottleneck too.