[sqlite] Speed issue of SELECT in my application

[Nick]

I have a table below in my application:

CREATE TABLE t1 (
        a INTEGER PRIMARY KEY AUTOINCREMENT, 
        b INTEGER NOT NULL UNIQUE, 
        c INTEGER NOT NULL, 
        d INTEGER, 
        e TEXT, 
        f INTEGER, 
        g INTEGER, 
        h TEXT, 
        i INTEGER, 
        UNIQUE(b, i)
        );
And I’ve got some speed issues when I query the db:
        SELECT b, c, d, e, f, g, h FROM t1 WHERE b >= 10000;

It needs almost 60ms as there are about 100 records with some long TEXT data
in the TEXT columns.  

I am wondering if it is needed to add ANY INDEX to improve the performance
of the SELECT?

Thanks.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users