[fdo-users] Slow FDO insert

Hans Milling hm at geograf.dk
Mon May 6 02:33:29 PDT 2013


Make sure there is no index on your table, and create them when you are done
inserting.
I work with MS SQL Server most of the time, but I think that this goes for
all databases.
If you can bundle multiple inserts in a single sql command (like 100-1000),
this can also speed things up a great deal.

Best regards
  Hans Milling...



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Slow-FDO-insert-tp5051522p5051527.html
Sent from the FDO Users mailing list archive at Nabble.com.


More information about the fdo-users mailing list