jbowman_1 Posted January 13, 2020 Share Posted January 13, 2020 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? Link to comment Share on other sites More sharing options...
trvpseudo Posted January 14, 2020 Share Posted January 14, 2020 pre filter the data 1st when u query the data (where ...) 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