On Sun, 02 Dec 2007 10:30:32 +0300, "M. Bashir Al-Noimi" <[EMAIL PROTECTED]> wrote:
>Hi All, > > >I wondered why SQLite is so slow by comparing with another database >drivers!, I got this conclusion by making a small test for SQLite, >Paradox, AbsoluteDB, and M$ Access drivers. > >The result as following: > >rows > SQLite Paradox AbsoluteDB Access >50 > 5906ms > 3ms > 2ms > 156 >100 > 11500ms > 17ms > 18ms > 297 >200 > 23422ms > 18ms > 32ms > 625ms >400 > couldn't adding more that 265 row per one process > 19ms > 78ms > 1187ms > > > >_*Note:*_ >To get binaries and source code of this test click here ><http://www.fileden.com/files/2006/7/22/140272/Spped%20of%20Adding.zip>. > > * Database examination.zip: written by Borland Delphi 7.0 (it > doesn't need depends to run executables) > >http://img338.imageshack.us/img338/4177/databaseexaminationue0.jpg ><http://img338.imageshack.us/img338/4177/databaseexaminationue0.jpg> > > * SimpleSQLite.zip: written by C++/Qt (it needs Qt open source > edition 4.3.1 to run executables) > >http://img338.imageshack.us/img338/2189/simplesqliteps6.jpg ><http://img338.imageshack.us/img338/2189/simplesqliteps6.jpg> My guess is you didn't use transactions. Issue a BEGIN TRANSACTION before the first INSERT and a COMMIT after the last INSERT. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
