Thank you very much, Romy!<br><br>What you suggested about the properties did the trick. Now FDO inserts are about 2 times faster than unoptimized SQLite inserts.<br><br>Thanks again to all of you!<br><br>Best regards,<br>
Igor<br><br><br><div class="gmail_quote">On Tue, Apr 27, 2010 at 3:14 PM, Romica Dascalescu <span dir="ltr"><<a href="mailto:Romica.Dascalescu@autodesk.com">Romica.Dascalescu@autodesk.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi Igor,<br>
<br>
You should not clear the property values collection, you should just set the new values to the property value and set null for null properties.<br>
Also the slow insert can be because 3.4 provider uses file journal, 3.5 provider uses memory journal.<br>
<br>
Regards,<br>
Romy<br>
________________________________________<br>
From: <a href="mailto:fdo-users-bounces@lists.osgeo.org">fdo-users-bounces@lists.osgeo.org</a> [<a href="mailto:fdo-users-bounces@lists.osgeo.org">fdo-users-bounces@lists.osgeo.org</a>] On Behalf Of Jackie Ng [<a href="mailto:jumpinjackie@gmail.com">jumpinjackie@gmail.com</a>]<br>
Sent: Tuesday, April 27, 2010 5:53 AM<br>
To: <a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
Subject: [fdo-users] Re: SQLite provider and transactions/batch inserts/<br>
<div><div></div><div class="h5"><br>
Hi Igor,<br>
<br>
I use the following bulk insert logic for FDO Toolbox. It is based on the<br>
SQLiteConverter implementation, and has no adverse performance effects (that<br>
I know of) for other providers:<br>
<br>
Create the fdo insert command *ONCE*<br>
Obtain a pointer/reference to its PropertyValues collection<br>
<br>
For each feature to be inserted:<br>
- Clear this collection<br>
- Load up with property values to be inserted<br>
- Execute the insert command<br>
- Repeat<br>
<br>
The key here is creating the insert command once, and reusing the property<br>
value collection repeatedly.<br>
<br>
Since you're working with C++ directly, you might as well look at the<br>
SQLiteConverter source as it does what I just described.<br>
<br>
- Jackie<br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/SQLite-provider-and-transactions-batch-inserts-tp4962263p4967766.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/SQLite-provider-and-transactions-batch-inserts-tp4962263p4967766.html</a><br>
Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
</div></div><a href="http://lists.osgeo.org/mailman/listinfo/fdo-users_______________________________________________" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users_______________________________________________</a><br>
<div><div></div><div class="h5">fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
</div></div></blockquote></div><br>