have you try this on usb key ? i've very bad benchmark on this, try in
hard disk in this case
Sylko Zschiedrich a écrit :
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
