Perfion Database Installer - Latest Version

Database triggers has been refactored for better performace

A few database triggers have been refactored to only run if there are any changes. This potentially improves the performance of the system.

A few new indices have been added to the database

A few new indices have been added to the SpecsIX, ImportLogs and TaskLogs tables. This is to improve performance of certain queries.

Performance

Various performance updates to improvae handling of database triggers.

Action log messages was truncated to 200 characters

Previously any Action log messages would be truncated to 200 characters, potentially removing important context information from the messages. This has now been extended to max. 4000 characters instead.

Actions - All ignore flags on Action groups are removed

All ignore flags on Action groups are removed to let all Actions continue working. An ignored group will ignore all child commands or groups.

Database transaction isolation level changes

To minimize the amount of database locks used when reading and writing data to the database, Perfion now uses the Read Committed Snapshot feature of SQL Server. This is an optimistic locking mechanism, where SQL Server will take a copy of the data targeted for update, allowing other users to read the existing data without further locking. Note that the copy will, per default, be placed in the tempdb, so this change may result in more load and disk usage in the tempdb.

Length of Remote Connection configuration has been extended

Previously, the length of a Remote Connection configuration was limited to 512 characters. This has been extended to 4000 characters.