SqlCeTransaction and InsertPerofrmance

  • Thread starter Thread starter Boas Enkler
  • Start date Start date
B

Boas Enkler

Hi

How does SqlCeTransaction influence the performance of many inserts?
What kind of isolation level should be used for best performance?
 
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.
 
Back
Top