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
