Versions Compared

Old Version 26

changes.mady.by.user Peter Christoffersen

Saved on

compared with

New Version 27

changes.mady.by.user Kristine

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Version: 2023-

R1-SR2

R2 (5.

2

3.

1

0)

Release date: 27 June 31 October 2023

The Perfion Database Installer is needed to install a new database or upgrade an existing Perfion database to the latest release.

View file
nameInvalid file id - 5f511e51-2c91-4f73-87da-2e72ef60f24cPerfion.DBInstaller 2023-R2 (5.3.0).zip

Related guides:

Database - Installation guide

Release notes

2023-
R1-SR2
R2 (5.
2
3.
1
0)

Release note title

Release note

New

Indexes at Specs

For performance optimization four new indexes are added to table Specs: IX_Specs_SpecType, IX_Specs_String, IX_Specs_Number and IX_Specs_Date.

2023-R1 (5.2.0)

Release note title

Release note

Foreign key on table MultiFactorAuthentication changed

Delete Cascade added to the foreign key FK_MultiFactorAuthentications_to_Users on table MultiFactorAuthentications.

Action Commands and Job Execution

Action Commands and Job Execution is refreshed in the database and it is not possible to edit the data in the clients anymore.

Support for MS SQL server version 2022

Perfion is now supporting MS SQL server version 2022

Table Designer Style added to Database installer

A default Table Designer Style added to the Database installer, so new Databases include a default style

Installation of Actions, Table Features and ECommerce

The installation of Actions, Table Features and ECommerce is moved from Settings to the DB installer. The installation will automatically be executed when the system is updated to 2023-R1 or above

index added to SpecsLog

The IX_SpecsLog_Item_LogKind index has been introduced to SpecsLog.

DB Installer prompts for DB Maintenance Tasks creation

The DB Installer inquires if the user wishes to create the System Tasks "Update Database Statistics" and "Rebuild Database Indices" if absent. Acceptance creates these tasks. Declining still creates them, but in a disabled state.