OpenAccess: How to improve peformance ?

3 posts, 0 answers
  1. Seabus
    Seabus avatar
    33 posts
    Member since:
    Jun 2011

    Posted 14 Jul 2011 Link to this post


    I'm looking at this chart ( ) and I see that OpenAccess should have no issues with creating 6000 objects per second ....However , in my app. it takes 2 minutes to save 30 000 objects ......Am I doing something wrong ?

  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 26 Jul 2011 Link to this post

    Hello Seabus,
    Insert performance is related to many aspects, the size of your objects is related to the amount of data we have to send over the wire, if the object represents a class hierarchy maybe more than one table is touched. If you have indexes defined, the server will take longer to update them, if you send a huge amount of data in one transaction, the client and server memory consumption may grow which takes time as well. If there is a lot of traffic on the server, based on the isolation level, a lot of checks have to be done. All this can make your inserts slower. Usually the communication speed and memory availability is eating the performance.

    Can you give me a little more insides how your model looks like and how your relational server is configured?

    All the best,
    Jan Blessenohl
    the Telerik team

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  3. N Mackay
    N Mackay avatar
    250 posts
    Member since:
    Dec 2010

    Posted 09 Aug 2011 Link to this post


    I would ignore

    The site is a con quite frankly as it's set up by one of the solution providers mentioned on that site (

    It's unfortunate that when companies start researching ORM's they stumble on this site and it's misleading.

    In some cases the tests have been setup to favour the DataObjects framework. In other words, that site is not impartial, also the tests are most likely out of date. A lot depends the entity size as mentioned, network speed and especially server performance.

Back to Top