Yesterday (April 9, 2020), I had issued a PR to FransBouma's RawDataAccessBencher with the latest version of RepoDb, plus with the following updates:
- Upgrading the
System.Data.SqlClientto version4.8.0. - Referencing the
Microsoft.Data.SqlClientversion1.1.1. - Added the
Initialize()method in the BencherBase class.
By today (April 10, 2020), FransBouma reach out to me to have some collaborations about the PR (can be found here), in which was approved in few hours after.
Right after the PR's approval, I received a Tweet about the bencher's execution.
RepoDb remains as the fastest and the most-efficient in .NET ORM library in SET fetches. It is 2 years in a row as of writing this.
Please exclude the
HandCoded Materializerresult when the outcome of the bencher.
Result for NET Core (Set Fetches)
The actual result can be found here.
Result for NET Framework (Set Fetches)
The actual result can be found here.
Result for NET Core (Individual Fetches)
RepoDb has downed to 4th place (previous 1st place) in INDIVIDUAL fetches. See the result below.
The actual result can be found here.
The reason to this is the update at v1.10.x. There is a feature that has been introduced to RepoDb that needs to be executed in every calls to ExecuteQuery method. This would affect both the INDIVIDUAL and SET fetches. However, the library is fast enough when converting big chunk of records, the effect to SET fetches is not that much.
The actual post can be found here.
Top comments (0)