This question is locked. New answers and comments are not allowed.
Hi,
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,
Frederik
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,
Frederik
1 Answer, 1 is accepted
0
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.
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.