Database Reference
In-Depth Information
4
Bso wIll never dIe and here Is why
Dave Farnsworth
Contents
4.1
Who Should read This Chapter?
113
4.2 Prerequisites
114
4.3
Why BSo, Indeed
114
4.3.1
need for Speed
115
4.4
What Is “good” Performance?
115
4.4.1
know the Basics for good Performance
115
4.4.2
Dimensionality
115
4.4.3
Block Size mysteries
117
4.4.4
Dimension order
118
4.5
getting the most from multiple Processors
121
4.6
Cache Is king; know the Basics
121
4.6.1
Index Cache
122
4.6.2
Data Cache
123
4.6.3
Data File Cache
124
4.6.4
Calculator Cache
125
4.6.5
Dynamic Calc Cache
125
4.7
Check your Work
127
4 .7.1
Block Count as a Speedometer
128
4.7.2
Whoa! my Script Is Slow
130
4 .7. 3
Script variables: Are They useful?
132
4 .7. 4
reduce Processing and Simplify Code
133
4 .7. 5
Aggregate only What Is needed
135
4 .7. 6
Create Blocks Explained
137
4.7.7
What Do hey mean, Why Do I Care?
141
4.8
BSo matters and hen Some
142
4.1 who shoulD reaD this Chapter?
Writing a chapter about the block storage option (BSo) within Essbase comes with
a substantial amount of risk. no matter how carefully the topic is researched, there will
113
