On 5/27/17, Thomas Flemming <t...@qvgps.com> wrote: > Hi, > > I have a table Pois with points of interest (geogr. coordinate, label, > styleid) where I do regional querys using a rtree-index: > > SELECT Pois.* FROM Pois_bb, Pois WHERE y0 < -14.8600 AND y1 > -15.12862 > AND x0 < 30.46203 AND x1 > 30.00074766 > AND 18 BETWEEN z0 AND z1 > AND Pois_bb.Id = Pois.Id > Thats very fast, 50ms. > > The problem is, when I add a second condition to get certain poi-types only > in the area: > > AND styleid IN 1351,1362,1371,1374,1376,1542,1595,1597,1643,1762 > > The query becomes really slow, 800ms. > There is of course also an index on styleid. > > I also realized, just this query: > > SELECT * FROM Pois WHERE styleid IN > 1351,1362,1371,1374,1376,1542,1595,1597,1643,1762 > > is also slow for the first call. The second call is fast. > > (Using SQLite Expert Professional 3.5 for testing). > > Any ideas, how to speed this up?
Have you tried running ANALYZE on your database? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users