Hi, I'm testing index on sqlite ver 3.0.7.
I've create a really simple database
CREATE TABLE tbl1(rowid integer primary key,fld1 text,fld2 integer);
and fill it with 1000000 row like this
insert into tbl1(fld1,fld2) values("blablablablablablabla",759928);
Then I copy this test.db to test-index.db and add a index (on test-index.db)
CREATE INDEX ind1 on tbl1(fld2);
When I do something like
time sqlite3 test.db "select * from tbl1 where fld2=12345;" > /dev/null
real 0m3.879s
user 0m3.188s
sys 0m0.650s
and
time sqlite3 test-index.db "select * from tbl1 where fld2=12345;" > /dev/null
real 0m0.019s
user 0m0.006s
sys 0m0.006s
I'm happy... index work very well...
but...
time sqlite3 test.db "select * from tbl1 where fld2>12345;" > /dev/null
real 0m21.452s
user 0m20.503s
sys 0m0.809s
and
time sqlite3 test-index.db "select * from tbl1 where fld2>12345;" > /dev/null
real 1m15.840s
user 0m54.799s
sys 0m16.131s
make me very sad :(
It's a bug or mine mistake ?
P.S. Sorry for my english.
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Dai pił energia al tuo sport! Rigenera il tuo corpo in maniera naturale
* Grazie agli integratori sport che trovi solo su Erboristeria.com
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2379&d=25-9
