On Thu, Sep 5, 2013 at 12:15 PM, William Voorsluys <[email protected]>wrote:
>
> Option 3 is the fastest, but I feel there would a way of efficiently
> adding a greater number of features at a time to the shapefile within
> a transaction. On the other hand, a previous comment in this lists
> noted:
>
> > The above would work for mid-sized data transafers, for massive ones
> against
> > databases it's better to adopt some sort of batching to avoid having a
> single
> > transaction with one million inserts, e.g., insert 1000, commit the
> transaction,
> > insert another 1000, and so on.
> > This would work better against databases and against WFS servers,
> > but not against shapefiles, which instead work better with the massive
> insert...
> > to each his own.
>
Indeed, not using transactions and getting an append writer is the faster
option.
Shapefiles have no notion of a transaction, which is emulated by writing a
second shapefile and swapping files
on commit, that's why using transactions there is slow
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
