Le 04/11/2014 21:27, walter.nordmann a écrit : > Sandro Santilli-2 wrote >> You'll need to show the query and the definition of the tables >> involved in it (EXPLAIN >> <query> >> output also helps). > > that is exactly what i did. you can see the query and the explain-output one > post before. > > and here ist the table definition: > >
Hi, I don't know exactly why, but the code you inserted in your messages are not visible. They are only visible when using the web-based archives like nabble ... So apparently you have filters on geometries (with intersection test &&) but no spatial index on these geometries. Something like CREATE INDEX ON table USING GIST(way) could help _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
