On Mon, May 14, 2012 at 05:25:47PM +1000, Luca Morandini wrote: > On 05/14/2012 04:39 PM, Sandro Santilli wrote:
> >I've noticed that a single transaction takes a lot more time than multiple. > >This is because toTopoGeometry is an hard database writer and the transaction > >must keep track of all changes to eventually roll-back. The presence of > >sub-transactions make things somewhat worst. > > I see... well, having transactions similar to those in Oracle > certainly would not have hurt here. Please run the benchmark before jumping to conclusions. Looking forward for your numbers. --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users