This is a migrated thread and some comments may be shown as answers.

How are large number of inserts/updates/deletes handled?

1 Answer 46 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
DuelingCats
Top achievements
Rank 2
DuelingCats asked on 12 Sep 2012, 07:05 PM
I am in a situation where I will need to be doing a large number of updates/inserts and want to know how it is handled within the ORM? Is every update a single update statement sent to the database or is it sent in a bulk fashion? How about inserts and deletes? 

1 Answer, 1 is accepted

Sort by
0
Ralph Waldenmaier
Telerik team
answered on 13 Sep 2012, 02:32 PM
Hi DuelingCats,

The insert and updates performed against the database are done with one statement per update/insert.  
We are performing bulk operations for delete statements using the IN statement. There we are deleting f.i. 10 entries per database call on most of the backends when there is only one primary key column defined on the table.

I hope this information is useful for you.
Feel free to ask if you have any other question.

Greetings,
Ralph
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Tags
General Discussions
Asked by
DuelingCats
Top achievements
Rank 2
Answers by
Ralph Waldenmaier
Telerik team
Share this question
or