[fdo-users] Re: SQLite provider and transactions/batch inserts/

Haris Kurtagic haris at sl-king.com
Tue Apr 27 06:05:41 EDT 2010

Hi Jackie,

Looking at Igor code I think he did just that first time around. He will
recheck it soon ( today is holiday in our country :) )

I am wondering if you can run some test in FDO Toolbox to test insert speed
for  100 or 1000 inserts for FDO-SQLite ?


On Tue, Apr 27, 2010 at 11:53 AM, Jackie Ng <jumpinjackie at gmail.com> wrote:

> Hi Igor,
> I use the following bulk insert logic for FDO Toolbox. It is based on the
> SQLiteConverter implementation, and has no adverse performance effects
> (that
> I know of) for other providers:
> Create the fdo insert command *ONCE*
> Obtain a pointer/reference to its PropertyValues collection
> For each feature to be inserted:
> - Clear this collection
> - Load up with property values to be inserted
> - Execute the insert command
> - Repeat
> The key here is creating the insert command once, and reusing the property
> value collection repeatedly.
> Since you're working with C++ directly, you might as well look at the
> SQLiteConverter source as it does what I just described.
> - Jackie
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/SQLite-provider-and-transactions-batch-inserts-tp4962263p4967766.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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100427/90a6eb34/attachment.html

More information about the fdo-users mailing list