c# - EF5 Edmx / Code First vs EF6 Edmx / Code First -


i busy moving complex data model ef5 ef6 , in process noticed serious performance issues ef6 (v6.1.0). whether running complex data model or simple one, performance issues obvious. following test performed on simple data model containing 5 tables 5 columns each, queering single table containing 200 records. machine i7 3.4ghz 8gb ram, ssd. console application on .net 4.5.

// first run var sw = system.diagnostics.stopwatch.startnew(); eftestcontext ctx = new eftestcontext(); var data = ctx.table1.tolist(); // table 200 records  ctx.dispose(); // second run console.writeline(string.format("completed in {0}ms", sw.elapsedmilliseconds)); sw.restart(); ctx = new eftestcontext(); data = ctx.table1.tolist(); ctx.dispose(); console.writeline(string.format("completed in {0}ms", sw.elapsedmilliseconds)); 

results following:

  • ef5 code first – 501ms / 2ms
  • ef5 edmx – 226ms / 2ms
  • ef6 code first – 1346ms / 3ms
  • ef6 edmx – 1189ms / 3m

generating views on ef6 improve performance still doesn't come close ef5 start-up , query time.

i must missing something? microsoft announced performance enhancements (initialization , query) on ef6? aware there performance issues reported on v6.0.0 reportedly have been addressed in v6.1.0? please advise.


Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -