Thursday, May 4, 2017

Planning performance for Business Rules and Calc Scripts

Recently, we migrated some BR and Calc Scripts from an older release 11.1.1.3 to 11.1.2.4 and some of the performance settings needed to be tuned.

One of the ones i came across was the I/O Access Mode and Data Compression settings to improve performance. Check that compression settings are still present. 

In EAS, expand the application and database. Right-click on the database > Edit > Properties > Storage tab. Check that your "Data compression" is not set to "No compression" and that "Pending I/O access mode" is set to "Buffered I/O". 

Sometimes the compression setting can revert to "no compression", causing the rapid growth of the data files on disk.