[fdo-users] Bulk Insert in Sqlite

[Romica Dascalescu]

Hi Bruno,

Bulk insert is not supported by sqlite, however you can use a transaction which will do the same thing.
Try using the same insert command, same property values collection and same property values, do not create each time property values just set the value or null and re-execute the insert command.
You can commit when you think you should, this way you get a fast 'bulk insert' :)

Romy.

-----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   =
(FdoIInsert*)connectionPtr->CreateCommand(FdoCommandType_Insert);
FdoPtr<FdoBatchParameterValueCollection>  batchParamPtr =
insertPtr->GetBatchParameterValues();

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?

Bruno
-- 
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
http://lists.osgeo.org/mailman/listinfo/fdo-users