[fdo-users] Slow FDO insert

Matteo matteo.conte1979 at libero.it
Tue May 7 14:40:02 PDT 2013


Hello Martin,
   the amount of data is about 500 feature. I have tried both with the
provider SHP locally or with a Postgres DB. Compared to the previous version
where I created for each entry, the Insert command I gained only 1 second.
The steps that execute are:
1) Create the FDO connection
2) Create the Insert command for each class (about 12 classes)
3) Create the properties collection for each command 
4) Read a text file in which each line:
    a) I read the coordinates and values
    b) check the Insert command
    c) Execute the Insert command.

Other ideas to improve performance?
Regards
Matteo



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


More information about the fdo-users mailing list