Fast commit

Thread is closed for posting
2 posts, 0 answers
  1. Frederik
    Frederik avatar
    12 posts
    Member since:
    May 2009

    Posted 28 May 2010 Link to this post


    I have i.e. 10000 items to be saved in a MS SQL Server 2008 Express. What is the fastest way to commit these changes? I takes ~6 seconds - can it run faster?
    I'm using the Scope and Transaction with the default settings.

    Best regards,
  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 01 Jun 2010 Link to this post

    Hello Frederik,
    It depends on the size of your objects, 3000-10000 per second should be possible. It is highly bound to your machine configuration as well.

    What you can test is how it performs if you do it in chunks of 2000 objects, maybe the client or server side memory is restricted.

    Best wishes,
    Jan Blessenohl
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top