Tag Archives: MustRead

1C:Enterprise 8 database storage structure

Publications: 1C:Enterprise 8 database storage structureThe information contained here is intended solely to understand the location and composition of data use by 1С:Enterprise and is intended for the developers of application solutions and specialists involved in administration of 1С:Enterprise 8 information bases. The below information should not be used to work with these data using any methods not provided by regular mechanisms of 1С:Enterprise 8.
List of tables and objects is relevant for 1С:Enterprise 8.1. For versions 8.2 and 8.3 it is applicable almost entirely, but is not complete.
Continue reading 1C:Enterprise 8 database storage structure

“1C:Enterprise 8” architecture as a product of engineering idea (S.G. Nuraliev)

Publications: 1C:Enterprise 8 architecture as a product of engineering idea (S.G. Nuraliev)

In the article of the head of economic program development department of “1C” company Sergey Nuraliev the architectural and technological innovations implemented in “1C:Enterprise” are examined, which have identified in aggregate a number of completely new technologies of business application development and new qualities of these applications.
The article is published in the newspaper PC Week/Russian Edition (published under license of international publishing house Ziff-Davis Media Inc.), NN 46 , 47 and 48 in 2004. This article version is published with permission of PC Week/RE. A number of additions are included in it which were included in newspaper version for the technical reasons, as well as the illustrations are added.
“1C” company thanks the editors of PC Week/RE for cooperation and assistance in the preparation of this article for publication.

Continue reading “1C:Enterprise 8” architecture as a product of engineering idea (S.G. Nuraliev)

Typical reasons of non-optimal query operation and optimization methods

Publications: Typical reasons of non-optimal query operation and optimization methods
The article presents the typical reasons of non-optimal operation of queries diagnosed at the configuration code level and considers the techniques if query optimization.

A significant part of problems that lead to the non-optimal query operation is detected by analysing the configuration code and metadata structure. There is a list of typical errors of the code and data structure whose consequences are fairly well studied and easily predictable. The code analysis using this list allows solving most of the problems with query performance without going into the detailed technical information (query text in the SQL language, query plan, etc.).
Continue reading Typical reasons of non-optimal query operation and optimization methods