[Qgis-developer] why Difference takes much more time then Clip?

2014-07-01 Thread G. Allegri
I'm doing some tests on fTools/Processing spatial operators, with a cover multilinestring layer and a base polygon layer. Running the following query on PostGIS I get similar timings with st_intersection and st_difference: select l.osm_id,ST_intersection(l.geom,e.geom) as geom from

Re: [Qgis-developer] why Difference takes much more time then Clip?

2014-07-01 Thread G. Allegri
To be correct, the two postgis queries are: select min(l.osm_id),st_difference(l.geom,st_union(e.geom)) as geom from linee_selezione_s l join edifici_buffer_s e on ST_Intersects(l.geom, e.geom) group by l.geom select min(l.osm_id),st_intersection(l.geom,st_union(e.geom)) as geom from

Re: [Qgis-developer] why Difference takes much more time then Clip?

2014-07-01 Thread G. Allegri
Just two graphics two show a brutal benchmark (measuring time in every cycle step). Clip: http://cdn.img42.com/31e0205c1273a1d1c705e5109da48db1.png Difference: http://cdn.img42.com/eeba68e62ea7d4db50662c2745a6d912.png 2014-07-01 20:05 GMT+02:00 G. Allegri gioha...@gmail.com: To be correct,