As mentioned in Chapter 8, Dashboard Data Connectivity, being able to schedule Web Intelligence (Webi) reports instead of running live queries for each and every query will help improve performance drastically.

Let's take an example where it takes two minutes to execute a query. If we were to have the dataset prescheduled instead of running live, we could retrieve the data in seconds rather than minutes.

There will be people who complain that your database architecture or query strategy is incorrect if it takes two minutes to execute a query. However, a lot of times it is impossible to speed up a query due to the sheer size of data or the amount of work it would take to re-architect the entire data warehouse.