Optimization




FunctionalityAfterBeforeResult of changes
Charts.
Upgrade: improved performance of charts that contain large data sets.

We recommend that you analyze charts in your applications and refactor them as follows:

  • The initial data population is performed on the server.
  • Major data changes (including data repopulations) are performed on the server.
  • Minor data changes can be performed on the client.
Inefficient performance of charts that contained large data sets.Improved performance of charts that contain large data sets.
Administration tools.
Upgrade: the user list in Designer opens faster. The improvement is noticeable if the list contains many users and roles. In an infobase that contained many users and roles, the user list opened slowly.The user list opens faster.
Accounting registers.
Accumulation registers.
Upgrade: faster totals recalculation for accounting registers and accumulation registers in the following cases:
  • During Verify and repair operation in Designer.
  • Using the RecalcTotals() method when the following conditions are met:
Totals recalculation for accounting registers and accumulation registers took a significant amount of time.Totals recalculation for accounting registers and accumulation registers takes less time.
Full-text search.
Upgrade: faster search for expressions like "word*" when an application has many instances of "word". Upgrade: exceeding search word threshold is less likely for expressions like "word*".

This upgrade is ignored in 8.3.13 version compatibility mode.

Search for expressions like "word*" could fail due to exceeding search word threshold error.Optimization of full-text search.
DBMS operations.
Upgrade: faster restructuring of infobases based on Microsoft SQL Server and IBM Db2.Restructuring of infobases based on Microsoft SQL Server and IBM Db2 took more time.Faster restructuring of infobases based on Microsoft SQL Server and IBM Db2.
DBMS operations.
Upgrade: simultaneous release of a number of connections with Microsoft SQL Server is less likely, which improves TempDB performance.There was a possibility of simultaneous release of a number of connections with Microsoft SQL Server, which significantly reduced TempDB performance.Optimized operation of TempDB on Microsoft SQL Server.
Calculation registers.
New feature: clustered index by recorder for calculation registers. An index is rebuilt during calculation register restructuring or during Verify and repair operation.

Upon deleting records from an effective period table, if there is no filter by register dimensions, the deletion query does not require establishing connection to the main register table.

Clustered index was not available for calculation registers.

Upon deleting records from an effective period table, if there was no filter by register dimensions, the deletion query always established connection to the main register table.

Reduced possibility of table lock upon deleting calculation register effective period records.

Comments
0
Add comment