Deploying 100-users 1C:DocFlow solution in Vietnam International Bank (VIB) we had to choose servers hardware characteristics for the system. We used the official 1C recommendations that can be find in this tech article. The main idea behind the article is that we can extrapolate the hardware component utilization of some live system (called Model) to our system, assuming that the model system users utilize the hardware components to the same extent as our users will.
Continue reading Example of choosing server-side hardware characteristics
Tag Archives: performance
1C:Enterprise 8 performance statistics on different equipment
Over the years of work with different customers, we have accumulated quite a lot of 1C:Enterprise performance statistics on different equipment.
Of course, performance is highly dependent on the particular solution used in the company, therefore, for the objective assessment we used the same test developed by our own.
As it is known, 1С performance consists of the speed of disk subsystems and processors.
Below there is a table with estimation of speed for the servers (workstations) with different disk subsystems, processors and main memory volume.
The higher “point” - the higher total performance of 1С.
it must be taken into account that this is only the statistical data and they should be used deliberately.
Continue reading 1C:Enterprise 8 performance statistics on different equipment
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
Optimization of client-server applications and features of their development to use in the service model. Part 2.
Let’s discuss the key development moments that affect the performance, resource intensity, reliability and correctness of application solution.
Many of these moments are already fixed as the standards in the System of standards and techniques of configuration development for the 1С:Enterprise 8 platform. Some of these moments are simply historically established practices of correct or, inversely, incorrect use of platform capabilities.
Optimization of client-server applications and features of their development to use in the service model. Part 1.
Continue reading Optimization of client-server applications and features of their development to use in the service model. Part 2.
Optimization of client-server applications and features of their development to use in the service model. Part 1.
Let’s discuss the key development moments that affect the performance, resource intensity, reliability and correctness of application solution.
Many of these moments are already fixed as the standards in the System of standards and techniques of configuration development for the 1С:Enterprise 8 platform. Some of these moments are simply historically established practices of correct or, inversely, incorrect use of platform capabilities.
Continue reading Optimization of client-server applications and features of their development to use in the service model. Part 1.
Scheduled operations at the DBMS level for MS SQL Server
Instruction to execute the scheduled operations at the DBMS level.
Information can be applied for the client-server variant of 1С:Enterprise 8 when using DBMS MS SQL Server.
Continue reading Scheduled operations at the DBMS level for MS SQL Server
Comparing the operation speed of 1C+MSSQL and file variant
The forums are constantly asking the same question: why 1C+MSSQL handles the requests slower than the file variant?
The usually the «flood» goes in a few dozen pages.
There are two popular «trends» in such forums — the first say that for the client-server variant this is normal, the file variant should always be faster, others say that 1С operates badly with DBMS.
Let’s try to find out.
Continue reading Comparing the operation speed of 1C+MSSQL and file variant