Hi Jackie,<div><br></div><div>Looking at Igor code I think he did just that first time around. He will recheck it soon ( today is holiday in our country :) )</div><div><br></div><div>I am wondering if you can run some test in FDO Toolbox to test insert speed for 100 or 1000 inserts for FDO-SQLite ?</div>
<div><br></div><div>Thanks,</div><div>Haris<br><br><div class="gmail_quote">On Tue, Apr 27, 2010 at 11:53 AM, Jackie Ng <span dir="ltr"><<a href="mailto:jumpinjackie@gmail.com">jumpinjackie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><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>
<font color="#888888">--<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>
</font><div class="im">Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
</div><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></div>