[fdo-trac] #735: Improve performance on GetGeometry

[FDO]

#735: Improve performance on GetGeometry
-------------------------------+--------------------------------------------
   Reporter:  maland           |       Owner:  gregboone
       Type:  enhancement      |      Status:  new      
   Priority:  major            |   Milestone:  3.6.0    
  Component:  ArcSDE Provider  |     Version:  3.5.0    
   Severity:  3                |    Keywords:           
External_id:                   |  
-------------------------------+--------------------------------------------
 We have done some profiling of the GetGeometry function in the ArcSDE
 provider. The performance when reading large geometries is rather poor. In
 one of our datasets we have rather large MultiLineString geometries, eg.
 one geometry consisting of 35581 lines (71260 points). For this particular
 geometry, the GetGeometry function takes 4-5 seconds to execute! The
 profiling reveals where the vast majority of the time is spent:

 {{{
 83 % : SE_shape_get_num_points
  9 % : FdoArrayHelper
 }}}

 I have attached a profiling screenshot for reference.

 The SDE API offers a SE_shape_as_WKB functions which runs in just 2-3
 milliseconds. Could that be used in conjunction with a Wkb2Fgf? That would
 greatly improve speed for large multi-geometries.

 Regards
 Henning Maland

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/735>
FDO <http://fdo.osgeo.org/>
Feature Data Objects