[mapguide-trac] #175: Unmanaged SHP File Locations Performance Issues as More Files get Added

[MapGuide Open Source]

#175: Unmanaged SHP File Locations Performance Issues as More Files get Added
-----------------------------------------------+----------------------------
 Reporter:  cgountanis                         |         Owner:       
     Type:  defect                             |        Status:  new  
 Priority:  high                               |     Milestone:  1.2  
Component:  Server                             |       Version:  1.2.0
 Severity:  major                              |    Resolution:       
 Keywords:  fdo,mapguide 1.2 beta 2, shp, dbf  |   External_id:       
-----------------------------------------------+----------------------------
Comment (by amorsell):

 Yes, enabling connection pooling for shape made a huge (positive)
 difference.  Performance is now acceptable.  I'm not sure the slow request
 every 10 minutes will be a large issue.  In my case, the slowness was not
 noticeable until fetching parcel polygon tooltips (10 seconds for each
 tooltip).  But, at a higher zoom factor, other shape files from the same
 unmanaged feature source are referenced in the map which is where I
 imagine it creates the initial XML config and caches it.

 One thing to note is that the default installation has connection pooling
 enabled, but the shape provider is excluded from pooling.  The default
 line in serverconfig.ini reads:

 DataConnectionPoolExcludedProviders = OSGeo.SDF,OSGeo.SHP

 So it must be edited and OSGeo.SHP removed.  Not a huge deal, but maybe it
 should be this way by default?

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/175#comment:10>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals