To find 32.0833 from field A, in Table T
Richard
PS: Nothing is index
On Thu, 06 Oct 2005 01:17:35 -0400, Puneet Kishor <[EMAIL PROTECTED]>
wrote:
On Oct 5, 2005, at 10:57 PM, Richard wrote:
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
there is no constraint in the above statement... you are selecting A
(which, I am assuming, is a column name) and a string that looks like a
number from table T. Is that what you really want?
And, finally, have you indexed the table?
--
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
--
Puneet Kishor
