Calc scripts and business rules are running slow compared to the Essbase v22.214.171.124 release. They are running 50-60% slower.
The Database is set to use Direct I/O vs. Buffered I/O. All performance tuning that has been done in 126.96.36.199.x is with Buffered I/O.
Set the database to use Buffered I/O instead of Direct I/O. In Essbase Adminstration Services Console:
1. Expand to the database.
2. Right-click on the database name and Edit->Properties.
3. On the Storage Tab, change the Pending IO Access Mode to Buffered I/O.
4. Stop/Start the application.
5. Run a restructure on the database.