<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>You can see how ogr2ogr uses this by looking at code starting</div><div><a href="http://trac.osgeo.org/gdal/browser/trunk/gdal/apps/ogr2ogr.cpp#L3304">http://trac.osgeo.org/gdal/browser/trunk/gdal/apps/ogr2ogr.cpp#L3304</a></div><div><br></div><div>the -gt argument sets the nGroupTransactions value</div><div><br></div><br><div><div>On Sep 17, 2013, at 4:22 PM, Bob Cave <<a href="mailto:bobc@bluemarblegeo.com">bobc@bluemarblegeo.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hello,<br><br>I have written a program that uses GDAL 1.9.1 to insert data into a<br>SQLite/Spatialite database, and I am running into performance problems with<br>large amounts of data. The SQLite/Spatialite section of the OGR<br>documentation says, "The -gt argument allows to explicitly set the number of<br>rows for each transaction. Explicitly defining -gt 1024 usually ensures a<br>noticeable performance boost; defining an even bigger -gt 65536 ensures<br>optimal performance while populating some table containing many hundredth<br>thousand or million rows." Apparently, the value associated with the -gt<br>parameter instructs OGR to commit the data after that number of rows have<br>been inserted.<br><br>How can I set the value associated with the -gt argument from within my<br>program? Is there another way to optimize performance when inserting many<br>rows? <br><br>Thank you,<br><br>Bob<br><br><br><br>--<br>View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Spatialite-Insert-Performance-tp5078349.html">http://osgeo-org.1560.x6.nabble.com/Spatialite-Insert-Performance-tp5078349.html</a><br>Sent from the GDAL - Dev mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br>_______________________________________________<br>gdal-dev mailing list<br><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/gdal-dev<br></blockquote></div><br></body></html>