Databases Reference
In-Depth Information
Advanced Techniques
Well here we are at a place in this topic where the information being presented to you
is not so much mandatory as it is optional, and it can be used as needed. In actuality,
the default settings with your Essbase installation are perfectly adequate for most
applications. It is only when your needs start to expand beyond the ordinary that you
will find yourself looking for ways to tweak your Essbase system performance.
In this chapter you will find a variety of database and system settings and adjustments
that will help you keep your Essbase database running at top performance.
While we highly recommend that you actually read this entire chapter the first time
through, it can also be used as a handy reference if and when you feel you may need
to enhance your current system's performance or make improvements that will allow
for trouble free growth in your system.
Performance tuning your database
Unlike many of the more typical relational database applications, Essbase has many
more database administrator options that can drastically affect the performance and
reliability of your Essbase database system.
Perhaps it's time to repeat what we've said before, "Essbase is an art, not a science."
There, we'll let that sink in a little bit.
What we mean by the previous and often repeated statement is that most of
the time your experience and good judgment can be far more valuable when
giving consideration to tuning your Essbase database than any stale old list of
hard-coded formulas.
