SqlCeTransaction and InsertPerofrmance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boas Enkler - 03 Apr 2006 09:54 GMT

Hi

How does SqlCeTransaction influence the performance of many inserts?
What kind of isolation level should be used for best performance?

Reply to this Message

Ginny Caughey [MVP] - 03 Apr 2006 16:06 GMT

Boas,

A single transaction for all the inserts would give you the best performance
as far as I know. There's really no substitute for doing timed tests with
the types and volume of data you expect to know for sure though.

Signature

Ginny Caughey
.NET Compact Framework MVP

> Hi
>
> How does SqlCeTransaction influence the performance of many inserts?
> What kind of isolation level should be used for best performance?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...