Dapper: Update benchmarks to include EF7

Created on 27 Feb 2015 · 6Comments · Source: StackExchange/Dapper

Would it be too early to request benchmarks be updated to include Entity Framework 7.
It is supposed to perform better and be more 'lightweight'..
Also I am not sure if this would depend on #241 .

Thoughts?

documentation entity-framework

Source

zam6ak

Most helpful comment

The EF6 performance results are already much better than indicated in the performance chart. Can we get an updated performance chart?

I'm getting these numbers in the performance test with EF 6.1.3

Running 500 iterations that load up a post entity
50ms hand coded
55ms Dynamic Mapper Query (buffered)
56ms Mapper Query (buffered)
56ms DataTable via IDataReader.GetValues
57ms PetaPoco (Fast)
59ms PetaPoco (Normal)
60ms Dapper.Cotrib
61ms Dynamic Massive ORM Query
63ms OrmLite QueryById
71ms BLToolkit
73ms Linq 2 SQL Compiled
75ms Simple.Data
75ms Susanoo Dynamic Mapping Static
79ms Mapper Query (non-buffered)
79ms Dynamic Mapper Query (non-buffered)
79ms Susanoo Dynamic Mapping Cache Retrieval
80ms Susanoo Mapping Static
81ms Susanoo Mapping Cache Retrieval
85ms Entity framework SqlQuery
92ms NHibernate Session.Get
93ms SubSonic Coding Horror
98ms NHibernate SQL
100ms NHibernate HQL
121ms NHibernate Criteria
143ms Entity framework No Tracking
144ms Linq 2 SQL ExecuteQuery
146ms Entity framework
324ms NHibernate LINQ
357ms Linq 2 SQL
2289ms SubSonic ActiveRecord.SingleOrDefault
Press any key to continue . . .

NickStrupat on 7 Apr 2015

👍3

All 6 comments

That's probably very worthwhile and overdue; it will require me to figure
out how to use EF 7, though - a direct upgrade might not be the most
appropriate comparison.

On 27 February 2015 at 03:20, zam6ak [email protected] wrote:

Would it be too early to request benchmarks be updated to include Entity
Framework 7 https://github.com/aspnet/EntityFramework.
It is supposed to perform better and be more 'lightweight'..
Also I am not sure if this would depend on #241
https://github.com/StackExchange/dapper-dot-net/issues/241 .

Thoughts?

—
Reply to this email directly or view it on GitHub
https://github.com/StackExchange/dapper-dot-net/issues/246.

Regards,

Marc

mgravell on 27 Feb 2015

I'd love to see the comparison once benchmarks are updated.
Thanks for considering it!

zam6ak on 2 Mar 2015

The EF6 performance results are already much better than indicated in the performance chart. Can we get an updated performance chart?

I'm getting these numbers in the performance test with EF 6.1.3

NickStrupat on 7 Apr 2015

👍3

README.md is still showing significantly inaccurate performance results for Entity Framework.

NickStrupat on 30 Nov 2016

@NickStrupat it's not, but we need to label the versions and do tests with many. This would also more accurately show the gains between EF versions for others to see. Is there an outstanding PR to update the benchmarks project? After MiniProfiler I can try and find time to re-run this on a controlled system.