[fdo-users] Slow FDO insert

[Martin Morrison]

I know you said in a later note that you solved your issue.  

But I have to ask why use MapGuide to load text data?  Why not just load it directly to the desired format and then refresh your map with the new layer?

Martin Morrison
Application Engineer
Engineering Design Systems, Inc.
3780 Peters Creek Rd Ext SW
Roanoke, VA  24018
540.345.1410
gis.edsi.com

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Matteo
Sent: Tuesday, May 07, 2013 5:40 PM
To: fdo-users at lists.osgeo.org
Subject: Re: [fdo-users] Slow FDO insert

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.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users