Surely ! I have to outline that grass export to postgis topology is still in beta mode. Also, I have a feeling the grass export to postgis topology uses the postgis topology functions, which kind of defeat the purpose (should bulk insert into tables).
I sent a separate message, but GEOS is also promising : 5 seconds to load everything, build topology, compute face, output faces, impressive! I shall have CGAL benchmark soon. Cheers, Rémi-C 2014-03-28 16:04 GMT+01:00 Sandro Santilli <[email protected]>: > On Tue, Mar 25, 2014 at 03:13:13PM +0100, Rémi Cura wrote: > > Back after some other testing . > > > > (_from memory, suppressing checks in addpoints was about 2 sec instead > of 3 > > sec. > > _About 21k unique points.) > > > > > > Here is a little comparison : > > (32k polylines,21k unique points, already 'topological'( no need to cut > > the lines) ,with a lot of attributes) > > > > Postgis Topology > > Postgis Topology (addtopogeom) : 700+ sec for 10k lines, (??about 1600 > sec > > for 32k lines??) > > Postgis Topology (addlinestring) : 240+ sec for 10k lines, (??about 780 > > sec for 32k lines??) > > Postgis Topology (addnode, addedge) : 80sec for 10 k lines (??about > 260sec > > for 32k lines??) > > > > Grass Gis 7 : > > Importing everything : 10 sec > > Importing only geom (no attributes) : 5 sec > > > > Importing everything then Exporting all topologies to postgis topology : > > 150 sec > > Declare postgis topo as external source and fill it with shapefile : 145 > sec > > Nice! GRASS seems to be the way to go here. > It's interesting to see how a 10-seconds process becomes a 150-seconds > one to ensure output is modeled after PostGIS/ISO model. There's maybe > space for optimization there. > > --strk; > > () ASCII ribbon campaign -- Keep it simple ! > /\ http://strk.keybit.net/rants/ascii_mails.txt > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
