There are many database caches and settings available to help you with optimizing your database.
As you know, optimally storing your data is the job of a properly configured database outline. A properly configured outline can also have an effect on calculation performance, data load performance, and data retrieval performance.
When it comes to loading, retrieving, calculating, and extracting your data, performance optimizing is the job of caches and buffers. During reporting, data retrieval cache and buffer settings are used to obtain optimal retrievals of the data.
One pair of settings that you cannot go wrong with is the Data retrieval buffers settings, found on the General tab of the Database ...