News, examples, tips, ideas and plans.
Thoughts around ORM, .NET and SQL databases.

Wednesday, July 29, 2009

Preliminary ORM performance comparison: DataObjects.Net 4 vs NHibernate

We've just adopted our CrudTest for NHibernate. First results:

DO4 (LINQ):
Insert: 28,617 K/s.
Update: 34,111 K/s.
Fetch & GetField: 8,682 K/s.
Query: 1,486 K/s.
CachedQuery: 8,176 K/s.
Materialize: 358,671 K/s.
Remove: 41,108 K/s.

NHibernate (LINQ):
Insert: 12,936 K/s.
Update: 12,939 K/s.
Fetch & GetField: 7,152 K/s.
Query: 95,7/s.
CachedQuery: Cached queries are not supported in NH yet.
Materialize: 37,892 K/s.
Remove: 13,012 K/s

The highlighted numbers show ~ 10 times difference, although DO wins in all other cases as well. Results of this test for several other ORMs are upcoming, the project will be shared @ Google Code.

In addition, we're developing general LINQ test as well. For now LINQ for NHibernate passes ~ 25 tests out of 100. This mean only very basic LINQ stuff really works on this release. DO4 passes ~ 98 tests there (it still misses passing arrays/collections as query parameters).

P.S. The optimization we've made during last 2 weeks is already quite successful (although we still work on materialization performance). Pre-optimization results can be found here.

19 comments:

  1. Very impressive. Well done, guys.

    ReplyDelete
  2. of course you missed the price / performance statistics.

    ReplyDelete
  3. Err... Is it normally provided in any other performance comparison? Is there a single performance score in our tests we can use? What should be done with differently priced editions of each product?

    In short, price / performance is actually a very subjective number.

    IMO, even this question is more meaningful: let's say you get 30% better performance for X$ (fixed amount of money) for your Windows Azure application requiring you to pay C$ / month in average. How much time would it take to return the initial investment of X$?

    ReplyDelete
  4. Do work calmly and slower: It may sound weird but try to do your work slower and finely. Don't do work in hustle or multitask. Trying to do so will only end up wasting your time. Studies show less than 2% people can do multitask effectively. Doing work slower will help you to focus better and keep you stress-free.
    Java Assignment help

    ReplyDelete
  5. Our online programming help services ensure students receive needed assistance to fulfill their desired academic goals.

    ReplyDelete
  6. I would like to thank you for the efforts you have made in writing this post. Thanks for posting Really Such Things. I should recommend your site to my friends.It is of a great advantage to take dissertation help. It eases the burden of students which they have to carry. Taking programming help also gives a lot of benefits to the students. Our UK essay writing expert are highly committed to helping academic students to finish their essay.

    ReplyDelete
  7. I would like to thank you for the efforts you have made in writing this post. Thanks for posting Really Such Things. I should recommend your site to my friends. It is of a great advantage to take dissertation proposal. It eases the burden of students which they have to carry. Taking philips marketing mix analysis and employee case study also gives a lot of benefits to the students.

    ReplyDelete
  8. I really happy found this website eventually. Really informative and inoperative! Thanks for the post and effort! Please keep sharing more such article. I've really like your blog and inspire me in many ways. We have already set a high standard for Coursework help.

    ReplyDelete
  9. This post is not just informative but impressive also. The post is so convincing that it created an urge to choose My Assignment Help services. You can email us at Info@Myassignmenthelpau.Com or Phone Number: +61-2-8005-8227

    ReplyDelete
  10. Wow, I have seen the most valuable and informative blog. Thanks for sharing. Visit for
    Web Design Company in Delhi

    ReplyDelete
  11. Get the Cheap dissertation help service with the best writers in town to get good grades in your academic writing.

    ReplyDelete
  12. Great information Technology is a better always. Morpheus tv Peggo apk Uktvnow

    ReplyDelete
  13. I found your site a bit interesting, so I like to visit your site repeatedly because; here I find all information is very useful and educational for me. book report

    ReplyDelete
  14. I would like to thanks for sharing high value and informative article with us. And i hope you'll sharing more idea's and keep writing more like this one.
    essay writer

    ReplyDelete

  15. A high-standard post with all imperative information about Assignment Help UK services. Looking forward to avail the premium services.

    ReplyDelete
  16. I would like to thanks for sharing high value and informative article with us. And i hope you'll sharing more idea's and keep writing more like this one. proofread my essay

    ReplyDelete
  17. I am very happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this best posting. Cost Accounting Assignment Help

    ReplyDelete
  18. Great site and a great topic as well I really get amazed to read this. It’s really good. I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. brass unjal chain

    ReplyDelete