Please post the output of the following command from the command-line shell:
.fullschema --indent
To capture the output of the above command, you can preceed it by
".once out.txt":
.once out.txt
.fullschema --indent
To emphasize, use the command-line shell "sqlite3.exe" which you can
obtain from the https://sqlite.org/download.html page. This is not a
3rd-party tool like SQLite Expert Professional.
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?
>
> Thanks
> Tom
>
>
> --
> /****************************************
> ** Flemming Software Development CC
> ** Thomas Flemming
> ** PO Box 81244
> ** Windhoek, Namibia
> ** http://www.quovadis-gps.com
> ** mail t...@qvgps.com
> ** +264 (0)81 3329923
> ** +49 (0)6182 8492599
> ***************************************/
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
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
