Do all insert's in one transaction and it will be done in 1 second or less.
Begin transaction 1..1000 insert into table Commit transaction Ciao Sylko -----Ursprüngliche Nachricht----- Von: Michael Martin [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 7. September 2007 10:06 An: [email protected] Betreff: [sqlite] SQLite or MS Access 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 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
