[fdo-users] Bulk Insert in Sqlite

Traian Stanev traian.stanev at autodesk.com
Mon May 31 11:09:38 EDT 2010

For bulk inserts, you can reuse the Insert command and its parameter collection -- internally the provider does its own batching, so you don't have to do it manually. There was a thread about this recently.


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
Sent: Monday, May 31, 2010 11:05 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Bulk Insert in Sqlite

I'm trying to do a bulk insert in the Sqlite provider ( the 3.6 version in
the trunk )

FdoPtr<FdoIInsert> insertPtr   =
FdoPtr<FdoBatchParameterValueCollection>  batchParamPtr =

my batchParamPtr is always null, normally this is when the providers does
not support batch insert

I know it should work because BulkCopy in Map3D 2011 works well with the
same Sqlite provider.

What's the trick?

View this message in context: http://osgeo-org.1803224.n2.nabble.com/Bulk-Insert-in-Sqlite-tp5122126p5122126.html
Sent from the FDO Users mailing list archive at Nabble.com.
fdo-users mailing list
fdo-users at lists.osgeo.org

More information about the fdo-users mailing list