Okay Steve,
I try this, please note: in PAN, there is no way for me to deselect
the other field ie: in this three field database, I do a search,
PAN will display all three field but with the found set, of the search
string.
Richard
On Thu, 06 Oct 2005 06:22:31 -0400, Steve O'Hara
<[EMAIL PROTECTED]> wrote:
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
