Your speed comparison is deeply flawed....... Your select statement is non-sensical (it returns 2 columns, A and '32.0883' with 9,337,681 records and you haven't told us if you're using PRAGMA synchronous = OFF;? Assuming you do a proper search like "select * from T where A='32.0883';" you should make sure A is indexed.
Try this and come back to us with the results:- sqlite3 test2.db create Table T (A, B, C ); PRAGMA synchronous = OFF; .separator , .import 'sqtest2.txt' T create index TA on T(A); select * from T where A='32.0883'; Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg] On Behalf Of Richard Sent: 06 October 2005 04:57 To: SQLite Users Mailing List Subject: [sqlite] Speed Test Done ! Importance: High Well, finally import 9,337,681 records into sqlite3 test2.db and ran the test. import sqtest4.txt : 2 min 28 seconds select A, '32.0833' From T ; 9 min 20 seconds -- I use another database for MacOS X also works on Windows, Call Panorama Did another test, comparing database... import sqtest4.txt : 36 seconds select from Field A contains 32.0833 / 55 seconds found 4322 records out of 9,337,681 Still have found no sql program yet, that can beat Panorama in speed. Regards- Richard Nagle CMS
