Databases Reference
In-Depth Information
CALCCACHELOW 50000000
:
; Sets up the analytic server to use multiple threading during
; data loads
DLSINGLETHREADPERSTAGE FALSE
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
;
; +++++++++++++++++++++++++++++++++++++++++++++
Coniguration categories
As you can see, making entries into the
essbase.cfg
file is a relatively easy task.
However, making good entries is where your Essbase knowledge and experience
pays off.
The following is a listing of the configuration categories and their general usefulness:
•
Ports and connections
: Most of these settings are obviously to help your
Analytic Server manage itself on the network and with other components.
•
Logging and error handling
: These settings help Essbase determine things
like the level of detail in an output log or the maximum number of lines
written during a process.
•
Calculation
: The calculation settings category has many settings that help
with system performance, mainly during calculation execution.
•
Hybrid analysis
: These settings do more for the configuration of Essbase's
interaction between itself and a backend relational database. This type of
data querying is known as hybrid analysis.
•
Query management
: These settings help with the special needs of
installations that make use of partitioned databases and heavy hybrid
analysis methods. There is not a lot here for overall system performance.
•
Memory management
: Now, here is a good category! We like this one so
much that we have given it its own separate section in this chapter. A definite
positive impact on system performance can be gleaned from these settings.
•
Data import/export
: Like the category name indicates, you can help improve
the overall performance of your data loading and data exporting processes.
•
Miscellaneous
: While some of these settings will end up being necessary for
your own installation, there really isn't any performance enhancing settings
in the miscellaneous category.