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?