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

[Haris Kurtagic]

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 ?

Thanks,
Haris

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