search

stophun / fdotoolbox

Automatically exported from code.google.com/p/fdotoolbox
0 stars 1 forks source link

Revert to FdoOutputOperation for SQL Server output connection #297

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
It has been determined that FdoOutputOperation will work for SQL Server if 
copying from a source whose geometry validity is unknown, as long as the newly 
introduced ForceWKB option is set to true.

Also FdoOutputOperation is 10x faster than raw SQL insert. 130,000 records only 
took 3.5 minutes to copy as opposed to 35 minutes!

Given these results, it makes sense to remove the SQL Server specific check and 
revert back to FdoOutputOperation. Documentation just needs to state that 
ForceWKB should be true if copying from sources where geometry validity is 
unknown.

Original issue reported on code.google.com by jumpinja...@gmail.com on 2 Aug 2010 at 11:03

GoogleCodeExporter commented 8 years ago 
Fixed in r1109

Original comment by jumpinja...@gmail.com on 2 Aug 2010 at 11:12