Database performance options

You can specify that cubes that have not been accessed for a specified period are unloaded from memory. Select Unload idle cubes and specify the idle period.

You can specify that cubes are optimized periodically. Select Optimize cubes and select the time at which the first optimization should occur and the interval between subsequent optimizations. An optimization re-indexes all cubes if more than 100,000 cell changes have been executed. The count is based on the number of changes on basic values. If there have been fewer than 100,000 changes, the cube is not optimized.

Although concurrent calculations of multiple requests are always distributed among available processor cores, the Multi-thread calculation option enables OLAP to take advantage of multiple cores for a single request. Calculation tasks of one request can then be split into separate threads, which can be run, in parallel, on different cores. This functionality is used especially when many values are expected during an aggregation. If multi-threading is off, each request is calculated by a single thread. But, if there are two or more concurrent requests, multiple threads can be calculated at the same time. For example, on a four-core system, four requests can be calculated at the same time, with negligible slow down.