Table of Contents
If a message contains repeating groups for Blocks and Legs then saving this information to DataBase significantly slows down the solution. To increase the performance of the solution the possibility to disable saving 'Blocks' and 'Legs' to the DB in ICE TC solution was implemented. By default saving is turned on but a user can easily disable it.
The Feature is available since FIXEdge 6.9.0.
Installation scripts contain a code to create the table "ICESettings", and populate it with several properties with the default values ("1" stands for "TRUE" meaning "saving is turned on").
User can change the default values by running SQL requests to change property values in "ICESettings" table or using Microsoft SQL Server Management Studio.
Performance measurement results (time to load SecDefs and UDS):
|enabled Blocks/Legs saving||disabled Blocks/Legs saving|
|first run (Empty DB)||16:45 min||7:26 min|
|second run (DB is already filled with the data from the first run)||12:02 min||5:42 min|
For full upgrade procedure follow the upgrade instruction.