Hello,
I have a huge SQL Server table with 210 millions of rows (yes... millions, 10 GB of disk space): recorded GPS positions with lat/lon.
every row as a foreign key that refers to a field track (425.000 tracks), so every track has thousands of GPS points that defines its geometry (a polyline).
I have to import all this data in a geodatabase file with a procedure in ArcGIS Desktop.
the real problem that is very time consuming is the Polyline creation starting from a List of double pair (lat and lon).
I found only a way: create a PolylineClass, cast it to IPointCollection, then, for every lat/lon pair, create a PointClass and adding it to the IPointCollection.
computation time in this way is literally dramatic.
Is there a way to efficiently create a Polyline starting from a huge number of double pairs?
