[sqlite] SQLite or MS Access

[Michael Martin]

Hi All,

 

I've done some benchmarks tests and I wonder where I've made a mistake.

 

In C# code with SQLite.NET.2.0.1 wrapper with sqlite 3.0:  1000 inserts
in a table of two columns -> 168 seconds

 

In C# code with Jet.Oledb.4.0 with MS Access:  1000 inserts in a table
of two columns ->  1.14 seconds

 

Could someone help me please

 

Thanks in advance