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
