SqlCeTransaction and InsertPerofrmance

[Boas Enkler]

Hi

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

 

[Ginny Caughey [MVP]]

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.