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.

25 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
  19. THANKS FOR INFORMATION

    you can search low-cost website with high-quality website functions.
    Today Join Us
    Call: +91 - 8076909847

    responsive website designing company in delhi

    levantro
    interior designer delhi


    livewebindia
    website designing company

    best seo services in delhi

    Best It Service Provider:

    1. Website Designing And Development.
    2. SEO Services.
    3. Software Development.
    4. Mobile App Development.

    ReplyDelete
  20. Get Online Assignment Helper Service by Professional Writers. Qualified Experts Provide You Help with Assignment. For all the students who are looking for help from professionals who can answer this question – who can do my assignment for me at cheap rates? we have the perfect answer. Our services are extended to both, college and university students so that they can attain the best grades possible. By taking the burden/ weight off their shoulders, we ensure enjoyment and relaxation during their years of education. therefore My Assignment Services serve students with the most reliable essay writing help, we have the best team of essay writers that help you in the best possible way, and get you the grades you want, and learning from the best possible source within the least possible time. My Assignment Services provide MYOB assignment help in Australia for over a decade for University and Colleges coursework. Hence, the assignments pertaining to such subjects would also be challenging.

    ReplyDelete
  21. This is an awesome motivating article! It is well-written and contains all the info, your Post is very unique and all information is reliable for new readers. We are an online homework help providers to USA students and all over the world. Thanks!! Keep Sharing :)
    Here you can check: homework help

    ReplyDelete
  22. Informative! This article is really good for all newbie here, great way of explanation and your post gave me a new perspective! I have read many other articles about the same topic, but your article convinced me. Thank you for sharing with us! My Assignment Help is a well-established and prominent name since almost a decade, receive valuable assignment help from the experts today!!
    Here you can check: My Assignment Help

    ReplyDelete


  23. السلامه عليكم ورحمة الله وبركاته نحن فى شركة الكمال نقوم بافضل واقوى المبيدات العالميه الموجودة

    التى تقضى على جميع الحشرات الطائره والزاحفة وابادة الحشرات
    شركة مكافحة حشرات بالطائف
    شركة مكافحة حشرات بجازان
    شركة مكافحة حشرات بحائل
    شركة مكافحة حشرات بحائل
    والسلامة عليكم وحمة الله وبركاته

    ReplyDelete