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

2 posts, 0 answers
  1. DuelingCats
    DuelingCats avatar
    49 posts
    Member since:
    Jul 2012

    Posted 12 Sep 2012 Link to this post

    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? 
  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 13 Sep 2012 Link to this post

    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!
  3. DevCraft banner
Back to Top