Issue with filters taking too long to load in Jaspersoft Report Server


We are using SQL and a view to get our data.

We are using ad hoc views to back the reports.

The database has alot of records.

When it goes to load the filters it is taking 1.5 minutes per filter to load.  There are 7 filters on the report that we are currently working with.

What options are there to minimize the load time for filters?  In the ad hoc settings there are two policies.  We have the Optimize Queries for Domain-based Reports checked and the Optimize Queries for JDBC-based Reports unchecked.  What is the recommended setting values when dealing with SQL databases and views?

jbowman_1's picture
Joined: Mar 7 2019 - 11:07am
Last seen: 2 weeks 16 hours ago

pre filter the data 1st when u query the data (where ...)

trvpseudo - 2 weeks 1 day ago

0 Answers:

No answers yet