> I cannot definitely solve your problem but I can think of some things to > try. First, do these: > > ANALYZE; > CREATE INDEX map_dsn ON map (d, s, n); > CREATE INDEX map_dns ON map (d, n, s); > > then execute the same SELECT. Does it have the same problem ? Does the > EXPLAIN QUERY PLAN tell you which of the (now) three indexes SQLite has > chosen. > > Just in case you didn't know, you can download the SQLite command-line > tool and execute SQL commands in it. This means you don't have to change > your own software. >
My current index is actually in the correct order of my query. I use 'n' and 's' and they are the first in the query. I am trying your suggestion to make the d first in the index as that is what is the limiting factor in the WHERE _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
