> Question, have you tried an index on class_dds, longitude_DDS, and > latitude_DDS? > > CREATE INDEX tableidx ON table (class_dds, longitude_DDS, latitude_DDS); > > Since all three fields are used in the query, I am curious if that would > help in any way. > Doesn´t do anything, there is something else going here, i think - it might well be that because of the order - statement, none of the indices is actually being used:
here some more timings (yours is at the end - the number between the timings is a count of the result sets just to make sure that they all return the right set of 11 results): No indices whatsoever: -- "TIME for Between statement:2794" -- 11 -- "TIME for <> statement:2775" -- 11 One index (longitude): -- "TIME for Between statement:2776" -- 11 -- "TIME for <> statement:2770" -- 11 two indices (longitude and latitude separetely): -- "TIME for Between statement:2786" -- 11 -- "TIME for <> statement:2792" -- 11 A 3 field index (class_dds, latitude_dds, longitude_dds): -- "TIME for Between statement:2783" -- 11 -- "TIME for <> statement:2762" -- 11 -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
