Created
November 22, 2016 15:10
-
-
Save FransBouma/e6ef3a7a1436825320fba32baf3bbd65 to your computer and use it in GitHub Desktop.
Micro bench results.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Results per framework. Values are given as: 'mean (standard deviation)' | |
| ============================================================================== | |
| Non-change tracking fetches, set fetches (25 runs), no caching | |
| ------------------------------------------------------------------------------ | |
| Handcoded materializer using DbDataReader : 127,21ms (5,73ms) Enum: 1,14ms (0,05ms) | |
| LINQ to DB v1.0.7.4 (v1.0.7.4) (compiled) : 143,27ms (4,10ms) Enum: 1,14ms (0,22ms) | |
| LINQ to DB v1.0.7.4 (v1.0.7.4) (normal) : 143,69ms (6,32ms) Enum: 1,26ms (0,20ms) | |
| PetaPoco Fast v4.0.3 : 153,44ms (7,92ms) Enum: 1,21ms (0,20ms) | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco with Raw SQL : 160,41ms (4,85ms) Enum: 1,08ms (0,22ms) | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco typed view with QuerySpec : 166,08ms (5,28ms) Enum: 1,10ms (0,07ms) | |
| PetaPoco v4.0.3 : 167,80ms (6,89ms) Enum: 1,27ms (0,06ms) | |
| ServiceStack OrmLite v4.5.4.0 (v4.5.4.0) : 168,63ms (8,40ms) Enum: 1,52ms (0,49ms) | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco typed view with Linq : 171,13ms (5,06ms) Enum: 1,05ms (0,09ms) | |
| Dapper v1.50.2.0 : 172,46ms (6,22ms) Enum: 1,26ms (0,08ms) | |
| Entity Framework v1.1.0.0 (v1.1.0.21115) : 185,22ms (3,17ms) Enum: 1,44ms (0,30ms) | |
| NPoco v3.4.6 : 209,39ms (7,11ms) Enum: 1,28ms (0,28ms) | |
| Non-change tracking individual fetches (100 elements, 25 runs), no caching | |
| ------------------------------------------------------------------------------ | |
| ServiceStack OrmLite v4.5.4.0 (v4.5.4.0) : 0,45ms (0,05ms) per individual fetch | |
| LINQ to DB v1.0.7.4 (v1.0.7.4) (normal) : 0,48ms (0,03ms) per individual fetch | |
| PetaPoco Fast v4.0.3 : 0,51ms (0,02ms) per individual fetch | |
| Handcoded materializer using DbDataReader : 0,52ms (0,08ms) per individual fetch | |
| LINQ to DB v1.0.7.4 (v1.0.7.4) (compiled) : 0,52ms (0,04ms) per individual fetch | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco with Raw SQL : 0,53ms (0,06ms) per individual fetch | |
| Entity Framework v1.1.0.0 (v1.1.0.21115) : 0,55ms (0,02ms) per individual fetch | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco typed view with QuerySpec : 0,70ms (0,01ms) per individual fetch | |
| NPoco v3.4.6 : 0,79ms (0,01ms) per individual fetch | |
| Dapper v1.50.2.0 : 1,03ms (0,06ms) per individual fetch | |
| LLBLGen Pro v5.1.0.0 (v5.1.0), Poco typed view with Linq : 1,43ms (0,01ms) per individual fetch | |
| PetaPoco v4.0.3 : 3,34ms (0,02ms) per individual fetch | |
| Complete. Press enter to exit. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment