Okay,,
Thanks to all, thanks to Robert, for the tweak on select string.
that work...
However, the select * from T where A = '32.0833' ;
work, and now the speed test report:
It found 2161 records, in 0.0075 seconds. ( out of 9,337,681 records )
Memory, did not jump that much, from 177 MB to 190 MB useages.
so, subtract the diff, and that is what sqlite3 is using doing all this....
Now, question,
can one load any and all database into memory? ( like Panorama ? )
or is this a freak speed test on searching string.
second, how often does a index need to rebuilt? 16 mins to create a index,
how long to rebuild it?
So, enclosing, PAN, had the fastest import time of 36 seconds,
and compare to this sqlite test, the second fastest time of finding of 55
seconds.
**** I need to do this test again, with that output string, where sql tell
the user, that search took x amount of second searching threw 9 million
records..
and found x amount of records that match string. ( aka Proof )
Regards-
Richard
