[fdo-users] Re: SQLite provider and transactions/batch inserts/
haris at sl-king.com
Tue Apr 27 06:05:41 EDT 2010
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
> 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:
> Sent from the FDO Users mailing list archive at Nabble.com.
> fdo-users mailing list
> fdo-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the fdo-users