Dapper icon indicating copy to clipboard operation
Dapper copied to clipboard

When there are too many parameters, parameterized insertion has performance problems.

Open 0611163 opened this issue 3 years ago • 0 comments

When there are too many parameters, parameterized insertion has performance problems.

bool add = !command.Parameters.Contains(name);

When the count of command.parameters is large, the performance is poor.

Used for batch insert by one SQL statement. Mabe a lot of parameters.

PR: https://github.com/DapperLib/Dapper/pull/1816

0611163 avatar Aug 12 '22 01:08 0611163