This question is locked. New answers and comments are not allowed.
Hi,
I'm looking at this chart ( http://ormbattle.net/ ) 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 ?
Seabus
I'm looking at this chart ( http://ormbattle.net/ ) 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 ?
Seabus
2 Answers, 1 is accepted
0
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
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!
0
N Mackay
Top achievements
Rank 1
Rank 1
answered on 09 Aug 2011, 10:10 AM
Seabus,
I would ignore ormbattle.net
The site is a con quite frankly as it's set up by one of the solution providers mentioned on that site (DataObjects.net).
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.
I would ignore ormbattle.net
The site is a con quite frankly as it's set up by one of the solution providers mentioned on that site (DataObjects.net).
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.