Optimization




FunctionalityAfterBeforeResult of changes
Information registers.
Implemented the cluster index based on dimensions of slice first and slice last physical tables of an information register.

Disabled index uniqueness verification.

Optimized performance of queries operating with slice tables.

This index can be built the following ways:

  • restructuring the information register
  • database restructuring when the verification and repair operation is performed.
Physical slice first and slice last tables were not indexed.

The performance of the queries operating with slice tables was not optimal.

Improved physical slice tables performance in configurations with large number of users. Eliminated deadlocks when updating the physical slice tables.
Full-text search.
Reduced the size of temporary files created during the update of full-text search index. This change affects infobases with many separators the most.

The new temporary file format is used when the compatibility mode is disabled.

This change is not implemented in version 8.3.12 compatibility mode.

Temporary files created during the update of full-text search index were significantly larger.Reduced the disk space allocated for a full-text search index generating when the infobase contains many separators.
DBMS operations.
Improved performance of virtual turnover tables of accumulation and accounting registers when they are grouped by day, month, or year, or when the BeginOfPeriod() query language function is used.

This change is available in all supported DBMS, except for Microsoft SQL Server versions earlier than 2012.

Performance of virtual turnover tables of accumulation and accounting registers when they were grouped by day, month, or year, or when the BeginOfPeriod() query language function was used, was suboptimal.Improved performance of virtual turnover tables of accumulation and accounting registers.
Common objects.
Improved performance of the following ValueTreeRowCollection object methods: Remove(), Insert(), Index(), and Move(). The performance of the following ValueTreeRowCollection object methods was insufficient: Remove(), Insert(), Index(), and Move().Improved performance of the value tree rows from 1C:Enterprise script.
External reports and data processors.
Improved performance of loading external reports and data processors opened by large number of users.Loading external reports and data processors opened by large number of users was longer.Improved performance of loading external reports and data processors opened by large number of users.
Background and scheduled jobs.
Configuration extensions.
Improved performance of second and further background job startups if they use the same set of configuration extensions. This change is available In file mode.In file mode second and further background job startups were longer even if they used the same set of configuration extensions.Improved background job startups in the file mode if they are operating with configuration extensions.
Common objects.
Optimized filling and deleting rows of a table of values.Filling and deleting rows of a table of values were longer.Improved table of values performance.
Web client.
Optimized page titles (tabs) rendering in the web client.Page titles (tabs) rendering in the web client was slow and suboptimal.Eliminated unexpected system behavior.
Common attributes / Data separation.
Improved opening forms performance in a configuration that uses common attributes.Forms opened relatively slow if a configuration used common attributes.Forms in a configuration that uses common attributes now open faster.
Data composition system.
Sometimes the data composition system template composer attempts to sort the data set by the DBMS means. The data composition system does not use it's own means in these cases. But the composition result may be incorrect because the row comparison operations are different in various DBMS and 1C:Enterprise platform.

This change is not implemented in version 8.3.12 compatibility mode.

Data composition system template composer always sorts the data set by the data composition system means.Improved the sorting performance during the report building in some scenarios.
Data composition system.
Improved the data composition system template generation if the data composition schema is composed of many queries that generate temporary tables with many fields that are not used in the composition process.The data composition system template generation process was longer if the data composition schema was composed of many queries that generated temporary tables with many fields that were not used in the composition process.Improved complex reports with many temporary tables building performance.
Queries.
If a query contains an IN subquery then a join with table from the IN subquery is used instead. This change is performed only if it does not affect the query result.

This change is not implemented in version 8.3.12 compatibility mode.

If a query contained an IN subquery, the DBMS always used this subquery.Improved the DBMS query plan in some scenarios.
Development tools.
Server clusters.
Improved the configuration database update performance when it is initiated from a debug session in client/server mode.The configuration database update was longer when it was initiated from a debug session in client/server mode.Improved the configuration database update performance when it is initiated from a debug session in client/server mode.
Spreadsheet documents.
Improved the CheckPut() method performance if a spreadsheet document contains multiple sheets.The CheckPut() method performance for a spreadsheet document with many sheets was insufficient. Improved performance of spreadsheet document display.
Spreadsheet documents.
Improved copying to clipboard performance. Improved the GetArea() spreadsheet document method performance when applied to the spreadsheet document area with multiple rows with custom column formatting.Copying to clipboard performance and the GetArea() spreadsheet document method performance when applied to the spreadsheet document area with multiple rows with custom column formatting were insufficientImproved performance of obtaining the spreadsheet document area with multiple rows with custom column formatting.
Spreadsheet documents.
Web client.
Improved performance of spreadsheet document groups collapsing and expanding in the web client.The collapsing and expanding of spreadsheet document groups in the web client was longer.Improved spreadsheet document performance in the web client.
Background and scheduled jobs.
Improved the background jobs execution and waiting for their completion.The background jobs execution and waiting for their completion were longer.The background jobs execution and waiting for their completion are now faster.

Comments
0
Add comment