Well, There must be something wrong with the test, you wanted me to run:
Welcome to Darwin! G4:~ rn$ sqlite3 SQLite version 3.2.5 Enter ".help" for instructions sqlite> create table T (A, B, C ); sqlite> .separator , sqlite> .import 'sqtest4.txt' T sqlite> create index I on T (A) ; sqlite> .output results.txt sqlite> select * from T where A=32.0833; sqlite> .output stdout sqlite> As you can see its the exact code, you wanted me to test. however, the results.txt was empty. But do have import time: 3 min 14 second and Over 12 Mins to index field A