Most of the data we publish to our intranet web gis (based on AIMS 2013) comes from Oracle via FDO Topobase provider. For performance reasons we have created an SDF file for the most often used base data - containing 30+ tables and 700'000 features. To my surprise the SDF file is not as fast as I expected. By changing the default value "DataConnectionPoolExcludedProviders" performance increased noticable.
By default SDF files are excldued from ConnectionPooling:
DataConnectionPoolExcludedProviders = OSGeo.SDF,OSGeo.SHP
By uncommenting the line and restarting AIMS things got better:
#DataConnectionPoolExcludedProviders = OSGeo.SDF,OSGeo.SHP
This has been mentioned before - but somehow I didn't know it. Here is an older reference:
http://zacster.blogspot.ch/2008/10/mapguide-performance-tips.html
In the next few days I will look into SQLite files as an alternative to SDF. A first test seems to be promising - SQLite file was much faster than SDF.
Map 2013, SP2
About things that happened to me at work.
Showing posts with label Web. Show all posts
Showing posts with label Web. Show all posts
Wednesday, 19 November 2014
Subscribe to:
Comments (Atom)