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.

39 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
  24. Allessaywriter.com can provide you all the answers regarding who can write my essay. In our service, we have some of the best essay writers who are professional in this field. We ensure a high quality work within the stipulated time. Not only that, but our prices are so reasonable that you do not have to peep into your pocket before hiring us.

    ReplyDelete
  25. Hiring an Essay Writer makes your task easier as you are able to get your essays and assignments done effectively and well in time. You may contact Assignment Help 4 Me to take help regarding your essays.

    ReplyDelete
  26. If you are also one of them who are still messing up the usage of Affecting versus effecting, read this blog to solve the issue. The blog discusses the difference between the two and also explains the usage of the words.

    ReplyDelete
  27. A lot of valuable information can be derived from the post. Certainly, this compelling post will encourage readers to choose Assignment Help Australia services. You can email us at info@firstassignmenthelp.com.

    ReplyDelete
  28. Paraphrase Generator: Paraphrase generator is the most important tool used by myassignmenthelp.com, you can use it to paraphrase your assignments.

    ReplyDelete
  29. I would like to pay my gratitude to you for sharing such an interesting and informative blog. Now, I would like to induce your attention to one of the leading Mobile App Development Company which excels in providing a wide range of Android and iOS app development services at affordable cost.

    ReplyDelete
  30. According to the case study,Organization Governance And Leadership Sally has been a senior manager at MTCR for four years and led a team in the customs services area of the company. On the other hand.

    ReplyDelete
  31. Carry out an analytical review on the financial statements of these companies in the planning phase and identify areas of concern (high risk or problem areas) or comfort. Cash Flow Analysis Woolworths LTD Justify your answer,

    ReplyDelete
  32. Nice Post
    My name is Joseph Wong and thanks for sharing this information.
    Get the best Assignment Help in Australia.
    Thanks.

    ReplyDelete
  33. Very nice blog and articles. I am really very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post. My Assignment help

    ReplyDelete
  34. Hey Folks! Very recent I found one of the most reliable yet affordable Assignment Help services. I have asked the professional writers to make assignments on my behalf. And the result I received was totally up to my expectation. I never thought I would be so happy to choose an online assignment writing service. It is my advice to visit their website once to get the most customized assignment writing solutions irrespective of subjects and types.

    ReplyDelete