> class_dds has a maximum value of 6, so there where-clause "class_dds<11" > is totally unecessary - if i ditch this part, the response time is > coming down to 900ms from 2700ms for my request. > I will now time again. > Some new timings - i basically got it. What I find to be weird is that just ONE index seems to yield the same results as several fields indexed:
no indices: -- "TIME for Between statement:2548" -- 11 -- "TIME for <> statement:2528" -- 11 -- "TIME for <> statement without ORDER BY-clause:1070" -- 11 -- "TIME for <> statement without ORDER BY-clause:987" -- 11 On index (longitude) - WHOAA!!!!!: -- "TIME for Between statement:18" -- 11 -- "TIME for <> statement:11" -- 11 -- "TIME for <> statement without ORDER BY-clause:10" -- 11 -- "TIME for <> statement without ORDER BY-clause:9" -- 11 two indices (longitude and latitude): -- "TIME for Between statement:11" -- 11 -- "TIME for <> statement:11" -- 11 -- "TIME for <> statement without ORDER BY-clause:10" -- 11 -- "TIME for <> statement without ORDER BY-clause:10" -- 11 3 field index (class_dds, longitude, latitude) - ?What gives?: -- "TIME for Between statement:2540" -- 11 -- "TIME for <> statement:2528" -- 11 -- "TIME for <> statement without ORDER BY-clause:999" -- 11 -- "TIME for <> statement without ORDER BY-clause:991" -- 11 a 2 field index (longitude, latitude): -- "TIME for Between statement:10" -- 11 -- "TIME for <> statement:11" -- 11 -- "TIME for <> statement without ORDER BY-clause:10" -- 11 -- "TIME for <> statement without ORDER BY-clause:9" -- 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
