Advertisement

**Not a member of Pastebin yet?**

**, it unlocks many cool features!**

__Sign Up__- client HW: Core2Duo quad, 4GB ram, Windows 8.0
- server HW: i5, 8GB ram, Windows Server 2012 64bit
- Network: 100BaseT / GB router
- +-------------------------------------------------------------------------------------------
- | Raw Data Access / ORM Benchmarks.
- | Code available at : https://github.com/FransBouma/RawDataAccessBencher
- | Benchmarks run on : dinsdag 11 februari 2014 16:17:52
- | Registered benchmarks :
- | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
- | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
- | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
- | Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
- | Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
- | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
- | Dapper. Change tracking: False. Caching: False.
- | Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: False. Caching: False.
- | Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: True. Caching: False.
- | LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
- | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
- | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
- | NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
- | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
- | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
- | ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
- | PetaPoco v4.0.3. Change tracking: False. Caching: False.
- | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
- | Run set benchmarks : True
- | Run individual fetch benchmarks: True
- | Number of set fetches : 10
- | Number of individual keys : 100
- | Release build : True
- | Client OS : Microsoft Windows NT 6.2.9200.0 (32bit)
- | Bencher runs as 64bit : False
- | CLR version : 4.0.30319.18408
- | Number of CPUs : 4
- | Server used : nerd.sd.local
- | Catalog used : AdventureWorks
- | SQL Server version used : 11.00.3128
- +-------------------------------------------------------------------------------------------
- Warming up DB, DB client code and CLR
- ====================================================================
- DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 51ms
- Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 53ms
- Number of elements fetched: 31465. Fetch took: 536ms. Enumerating result took: 50ms
- Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 564ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 553ms. Enumerating result took: 51ms
- Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 547ms. Enumerating result took: 51ms
- Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 51ms
- Starting benchmarks.
- ====================================================================
- Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
- Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
- Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
- Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 2709ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 559ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 576ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 569ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 581ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 562ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 560ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 538ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 529ms. Time per element: 5,29ms
- Number of elements fetched individually: 100. Total time: 221ms. Time per element: 2,21ms
- Number of elements fetched individually: 100. Total time: 214ms. Time per element: 2,14ms
- Number of elements fetched individually: 100. Total time: 222ms. Time per element: 2,22ms
- Number of elements fetched individually: 100. Total time: 216ms. Time per element: 2,16ms
- Number of elements fetched individually: 100. Total time: 216ms. Time per element: 2,16ms
- Number of elements fetched individually: 100. Total time: 220ms. Time per element: 2,2ms
- Number of elements fetched individually: 100. Total time: 221ms. Time per element: 2,21ms
- Number of elements fetched individually: 100. Total time: 220ms. Time per element: 2,2ms
- Number of elements fetched individually: 100. Total time: 219ms. Time per element: 2,19ms
- Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 6776ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6698ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6698ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6680ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6677ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6686ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6681ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6735ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6679ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 6754ms. Enumerating result took: 3ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
- Number of elements fetched individually: 100. Total time: 239ms. Time per element: 2,39ms
- Number of elements fetched individually: 100. Total time: 244ms. Time per element: 2,44ms
- Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
- Number of elements fetched individually: 100. Total time: 243ms. Time per element: 2,43ms
- Number of elements fetched individually: 100. Total time: 243ms. Time per element: 2,43ms
- Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
- Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
- Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
- Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
- Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 2802ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 1196ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1212ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1188ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1152ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1189ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1191ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1155ms. Enumerating result took: 3ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 142ms. Time per element: 1,42ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
- Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 2280ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1160ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1233ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 1249ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1244ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1201ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1202ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1195ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 1223ms. Enumerating result took: 3ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 53ms
- Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 51ms
- Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
- Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
- Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
- Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
- Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
- Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
- Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
- Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
- Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
- Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
- Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
- Dapper. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 519ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
- Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
- Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
- Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
- Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
- Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
- Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
- Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
- Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
- Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
- Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 635ms. Enumerating result took: 8ms
- Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 568ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 565ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 562ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 569ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 564ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 533ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 573ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 267ms. Time per element: 2,67ms
- Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
- Number of elements fetched individually: 100. Total time: 251ms. Time per element: 2,51ms
- Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
- Number of elements fetched individually: 100. Total time: 252ms. Time per element: 2,52ms
- Number of elements fetched individually: 100. Total time: 254ms. Time per element: 2,54ms
- Number of elements fetched individually: 100. Total time: 254ms. Time per element: 2,54ms
- Number of elements fetched individually: 100. Total time: 255ms. Time per element: 2,55ms
- Number of elements fetched individually: 100. Total time: 257ms. Time per element: 2,57ms
- Number of elements fetched individually: 100. Total time: 253ms. Time per element: 2,53ms
- Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 639ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 618ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 631ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 653ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 654ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 642ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 622ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 616ms. Enumerating result took: 3ms
- Number of elements fetched: 31465. Fetch took: 662ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 651ms. Enumerating result took: 3ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 269ms. Time per element: 2,69ms
- Number of elements fetched individually: 100. Total time: 265ms. Time per element: 2,65ms
- Number of elements fetched individually: 100. Total time: 267ms. Time per element: 2,67ms
- Number of elements fetched individually: 100. Total time: 264ms. Time per element: 2,64ms
- Number of elements fetched individually: 100. Total time: 264ms. Time per element: 2,64ms
- Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
- Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
- Number of elements fetched individually: 100. Total time: 265ms. Time per element: 2,65ms
- Number of elements fetched individually: 100. Total time: 262ms. Time per element: 2,62ms
- Number of elements fetched individually: 100. Total time: 266ms. Time per element: 2,66ms
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 754ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 744ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 753ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 729ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 709ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 712ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 716ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 748ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 737ms. Enumerating result took: 5ms
- Number of elements fetched: 31465. Fetch took: 749ms. Enumerating result took: 5ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 165ms. Time per element: 1,65ms
- Number of elements fetched individually: 100. Total time: 158ms. Time per element: 1,58ms
- Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
- Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
- Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
- Number of elements fetched individually: 100. Total time: 158ms. Time per element: 1,58ms
- Number of elements fetched individually: 100. Total time: 162ms. Time per element: 1,62ms
- Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
- Number of elements fetched individually: 100. Total time: 152ms. Time per element: 1,52ms
- Number of elements fetched individually: 100. Total time: 154ms. Time per element: 1,54ms
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 976ms. Enumerating result took: 16ms
- Number of elements fetched: 31465. Fetch took: 218ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 221ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 227ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 215ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 211ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 217ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 212ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 215ms. Enumerating result took: 7ms
- Number of elements fetched: 31465. Fetch took: 213ms. Enumerating result took: 7ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 166ms. Time per element: 1,66ms
- Number of elements fetched individually: 100. Total time: 35ms. Time per element: 0,35ms
- Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
- Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
- Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
- Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
- Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
- Number of elements fetched individually: 100. Total time: 32ms. Time per element: 0,32ms
- Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
- Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 759ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 654ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 693ms. Enumerating result took: 10ms
- Number of elements fetched: 31465. Fetch took: 676ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 685ms. Enumerating result took: 10ms
- Number of elements fetched: 31465. Fetch took: 693ms. Enumerating result took: 10ms
- Number of elements fetched: 31465. Fetch took: 680ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 684ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 682ms. Enumerating result took: 11ms
- Number of elements fetched: 31465. Fetch took: 689ms. Enumerating result took: 11ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
- Number of elements fetched individually: 100. Total time: 123ms. Time per element: 1,23ms
- Number of elements fetched individually: 100. Total time: 118ms. Time per element: 1,18ms
- Number of elements fetched individually: 100. Total time: 123ms. Time per element: 1,23ms
- Number of elements fetched individually: 100. Total time: 122ms. Time per element: 1,22ms
- Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
- Number of elements fetched individually: 100. Total time: 115ms. Time per element: 1,15ms
- Number of elements fetched individually: 100. Total time: 116ms. Time per element: 1,16ms
- Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
- Number of elements fetched individually: 100. Total time: 115ms. Time per element: 1,15ms
- NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 6238ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3934ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3903ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3889ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3929ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3871ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3925ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3906ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3912ms. Enumerating result took: 4ms
- Number of elements fetched: 31465. Fetch took: 3883ms. Enumerating result took: 4ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
- Number of elements fetched individually: 100. Total time: 135ms. Time per element: 1,35ms
- Number of elements fetched individually: 100. Total time: 131ms. Time per element: 1,31ms
- Number of elements fetched individually: 100. Total time: 133ms. Time per element: 1,33ms
- Number of elements fetched individually: 100. Total time: 131ms. Time per element: 1,31ms
- Number of elements fetched individually: 100. Total time: 133ms. Time per element: 1,33ms
- Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
- Number of elements fetched individually: 100. Total time: 126ms. Time per element: 1,26ms
- Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
- Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
- Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 1387ms. Enumerating result took: 210ms
- Number of elements fetched: 31465. Fetch took: 1219ms. Enumerating result took: 179ms
- Number of elements fetched: 31465. Fetch took: 1265ms. Enumerating result took: 174ms
- Number of elements fetched: 31465. Fetch took: 1290ms. Enumerating result took: 183ms
- Number of elements fetched: 31465. Fetch took: 1301ms. Enumerating result took: 206ms
- Number of elements fetched: 31465. Fetch took: 1230ms. Enumerating result took: 251ms
- Number of elements fetched: 31465. Fetch took: 1255ms. Enumerating result took: 181ms
- Number of elements fetched: 31465. Fetch took: 1292ms. Enumerating result took: 208ms
- Number of elements fetched: 31465. Fetch took: 1259ms. Enumerating result took: 283ms
- Number of elements fetched: 31465. Fetch took: 1264ms. Enumerating result took: 178ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
- Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
- Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
- Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
- Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
- Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
- Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
- Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
- Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 1333ms. Enumerating result took: 1612ms
- Number of elements fetched: 31465. Fetch took: 1270ms. Enumerating result took: 1676ms
- Number of elements fetched: 31465. Fetch took: 1336ms. Enumerating result took: 1557ms
- Number of elements fetched: 31465. Fetch took: 1340ms. Enumerating result took: 1562ms
- Number of elements fetched: 31465. Fetch took: 1294ms. Enumerating result took: 1636ms
- Number of elements fetched: 31465. Fetch took: 1226ms. Enumerating result took: 1656ms
- Number of elements fetched: 31465. Fetch took: 1294ms. Enumerating result took: 1631ms
- Number of elements fetched: 31465. Fetch took: 1299ms. Enumerating result took: 1648ms
- Number of elements fetched: 31465. Fetch took: 1326ms. Enumerating result took: 1578ms
- Number of elements fetched: 31465. Fetch took: 1281ms. Enumerating result took: 1687ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
- ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 713ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 593ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 581ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 99ms. Time per element: 0,99ms
- Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
- Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
- Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
- PetaPoco v4.0.3. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 515ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 526ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 2ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 376ms. Time per element: 3,76ms
- Number of elements fetched individually: 100. Total time: 376ms. Time per element: 3,76ms
- Number of elements fetched individually: 100. Total time: 374ms. Time per element: 3,74ms
- Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
- Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
- Number of elements fetched individually: 100. Total time: 374ms. Time per element: 3,74ms
- Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
- Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
- Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
- Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
- PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
- --------------------------------------------------------------------------------------------
- Set fetches
- -------------------------
- Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 498ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 498ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 509ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
- Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 3ms
- Single element fetches
- -------------------------
- Number of elements fetched individually: 100. Total time: 103ms. Time per element: 1,03ms
- Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
- Number of elements fetched individually: 100. Total time: 96ms. Time per element: 0,96ms
- Number of elements fetched individually: 100. Total time: 97ms. Time per element: 0,97ms
- Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
- Number of elements fetched individually: 100. Total time: 102ms. Time per element: 1,02ms
- Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
- Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
- Number of elements fetched individually: 100. Total time: 97ms. Time per element: 0,97ms
- Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
- Averaged total results per framework. Fastest and slowest result omited
- ==============================================================================
- Non-change tracking fetches, set fetches (10 runs), no caching
- ------------------------------------------------------------------------------
- Handcoded materializer using DbDataReader : 500,38ms. Enumeration average: 2,00ms
- PetaPoco Fast v4.0.3 : 502,00ms. Enumeration average: 2,00ms
- PetaPoco v4.0.3 : 515,88ms. Enumeration average: 2,00ms
- Dapper : 519,38ms. Enumeration average: 2,00ms
- Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 561,75ms. Enumeration average: 2,88ms
- Entity Framework v6.0.0.0 (v6.0.21211.0) : 564,75ms. Enumeration average: 2,13ms
- ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 589,75ms. Enumeration average: 2,00ms
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 736,00ms. Enumeration average: 5,00ms
- Oak.DynamicDb using dynamic Dto class : 1.269,50ms. Enumeration average: 199,50ms
- Change tracking fetches, set fetches (10 runs), no caching
- ------------------------------------------------------------------------------
- DataTable, using DbDataAdapter : 532,63ms. Enumeration average: 52,00ms
- Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 638,75ms. Enumeration average: 2,75ms
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 685,25ms. Enumeration average: 10,75ms
- Telerik DataAccess/OpenAccess Domain v4.0.3 : 1.191,38ms. Enumeration average: 3,00ms
- Telerik DataAccess/OpenAccess Fluent v4.0.3 : 1.218,38ms. Enumeration average: 3,00ms
- Oak.DynamicDb using typed dynamic class : 1.304,13ms. Enumeration average: 1.624,88ms
- NHibernate v3.3.1.4000 (v3.3.3.4001) : 3.910,13ms. Enumeration average: 4,00ms
- Entity Framework v6.0.0.0 (v6.0.21211.0) : 6.701,38ms. Enumeration average: 3,00ms
- Non-change tracking individual fetches (100 elements, 10 runs), no caching
- ------------------------------------------------------------------------------
- Dapper : 0,58ms per individual fetch
- Oak.DynamicDb using dynamic Dto class : 0,62ms per individual fetch
- ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 0,67ms per individual fetch
- Handcoded materializer using DbDataReader : 0,76ms per individual fetch
- PetaPoco Fast v4.0.3 : 0,99ms per individual fetch
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 1,55ms per individual fetch
- Entity Framework v6.0.0.0 (v6.0.21211.0) : 2,19ms per individual fetch
- Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,54ms per individual fetch
- PetaPoco v4.0.3 : 3,76ms per individual fetch
- Change tracking individual fetches (100 elements, 10 runs), no caching
- ------------------------------------------------------------------------------
- Telerik DataAccess/OpenAccess Domain v4.0.3 : 0,67ms per individual fetch
- Oak.DynamicDb using typed dynamic class : 0,67ms per individual fetch
- Telerik DataAccess/OpenAccess Fluent v4.0.3 : 0,69ms per individual fetch
- DataTable, using DbDataAdapter : 0,73ms per individual fetch
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 1,19ms per individual fetch
- NHibernate v3.3.1.4000 (v3.3.3.4001) : 1,33ms per individual fetch
- Entity Framework v6.0.0.0 (v6.0.21211.0) : 2,44ms per individual fetch
- Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,64ms per individual fetch
- Change tracking fetches, set fetches (10 runs), caching
- ------------------------------------------------------------------------------
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 217,25ms. Enumeration average: 7,00ms
- Change tracking individual fetches (100 elements, 10 runs), caching
- ------------------------------------------------------------------------------
- LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 0,45ms per individual fetch
- Complete. Press enter to exit.

Advertisement

RAW Paste Data
Copied

Advertisement