Richard wrote:
To find 32.0833 from field A, in Table T
Richard,
To correctly compare the speed of SQLite to Panorama running from memory
you need to do the following.
Start sqlite with no database file name. It will open a database in memory.
sqlite3
Now create your table and import your data.
create table T (A, B, C );
.separator ,
.import 'sqtest2.csv' T
Then, because you want to quickly search for records based on the value
of column A, create an index on column A.
create index I on T(A);
Now search for all records that match your constraint. Display all
columns for the found records. Note that this often be limited by screen
writing speed rather than search speed, so you should probably redirect
the output to a file first, and back to the screen after the search.
.output results.txt
select * from T where A=32.0833;
.output stdout
If you time these steps, I think you will be pleasantly surprised.
HTH
Dennis Cote
