ORMBattle.NETThe ORM tool shootout

  • Increase font size
  • Default font size
  • Decrease font size
Home

Results, August 2009

E-mail Print PDF

Scorecard

Remarks

    • Color bar: Green cells indicate better results; Red cells indicate worse results (the most "red" value is explicitly defined in Landmark column); Yellow cells indicate average results. Color bar is continuous, so all the intermediate colors can be used.
    • Above results are produced for 1000 item sequence. Complete ORMBattle.NET Test Suite output (for 100, 1K, 5K, 10K and 30K item sequences) is here.
    • LINQ implementation score is count of successfully passing LINQ query tests. There are 100 tests at all (not Microsoft LINQ 101 Samples tests!), so e.g. 98 means 2 tests had failed. Refer to LINQ tests description for further details.
    • Subsonic got zero score on this sequence because it does not support references (thus we were unable to compile the test for it). This will be fixed in near future.
    • Query test shows query compilation performance.
    • Compiled query test shows maximal query rate. If compiled queries aren't supported by a particluar framework (NH, Lightspeed, Subsonic), the number here is taken from Query test.
    • Query & materialize page derivatives show how many times per second an ORM can run a single query fetching N objects and enumerate all of them. N is page size, 20 for small page and 100 for large page.
    • Some ORMs win SqlClient on CUD tests because of command sequence batching, prepared statements and other tricks that aren't used in SqlClient test. Since this happens fully automatically and transparently for developers, we think this is fully honest.

      Charts

      LINQ implementation score

      LINQ queries performance ORM materialization performance

      ORM fetch performance Create, Update and Delete performance

      Paging performance CUD average

      As it was mentioned, above results are produced for 1000 item sequence. Complete ORMBattle.NET Test Suite output (for 100, 1K, 5K, 10K and 30K item sequences) is here.

       

      Polls

      Which test must we add next?
       

      Subscribe to our blog


      mother of bride dress