LinqConnect Documentation
Performance

Any ORM-framework is an additional tier between application and database server that leads to the performance decreasing in comparison with native SQL statement execution. In LinqConnect a set of the solutions for performance increasing was implemented. We will consider these methods in this article.

We can mark out two ways of performance increasing:

  1. Data fetching speed increasing
  2. Data editing speed increasing

We consider the following approaches of the data fetching performance increasing in this article:



You can increase speed of data update with the help of the following approaches:


The monitoring of the generated SQL statements is very important for the performance analysis. LinqConnect offers the following ways for monitoring SQL statements: