134 | | || !DataConnectionPoolExcludedProviders || || 0 <= Length <= 1024 [[BR]]Value = provider name(s) separated by ","[[BR]]Example: OSGeo.SDF,OSGeo.SHP|| The list of providers to exclude from connection pooling. || |
135 | | || !DataConnectionPoolSize || || 1 < Value <= 1024 || Default # of FDO connections to cache per provider || |
136 | | || !DataConnectionPoolSizeCustom || || 0 <= Length <= 1024 [[BR]] Example: OSGeo.SDF:10,OSGeo.SHP:10 || Custom # of FDO connections to cache for specified provider || |
| 139 | || [#ServerDataConnectionPoolExcludedProviders DataConnectionPoolExcludedProviders] || || 0 <= Length <= 1024 [[BR]]Value = provider name(s) separated by ","[[BR]]Example: OSGeo.SDF,OSGeo.SHP|| The list of providers to exclude from connection pooling. || |
| 140 | || [#ServerDataConnectionPoolSize DataConnectionPoolSize] || || 1 < Value <= 1024 || Default # of FDO connections to cache per provider || |
| 141 | || [#ServerDataConnectionPoolSizeCustom DataConnectionPoolSizeCustom]|| || 0 <= Length <= 1024 [[BR]] Example: OSGeo.SDF:10,OSGeo.SHP:10 || Custom # of FDO connections to cache for specified provider || |
| 147 | === !CacheSize ===#ServerCacheSize |
| 148 | The !MapGuide Server uses schema and class definition information in many requests. Caching this information locally increases server throughput and increases the memory footprint. !CacheSize controls how many objects the server will cache. If sufficient memory is available, the !CacheSize should be set to the total number of feature classes visible from all feature sources. |
| 149 | === !DataConnectionPoolExcludedProviders ===#ServerDataConnectionPoolExcludedProviders |
| 150 | By default, SDF data sources do not use pooled connections. This allows read/write operations to occur. Some performance improvement can be obtained by enabling connection pooling for SDF and SHP. Note: Turning on connection pooling for SDF will make SDF unsuitable for FDO update operations. If temporary layers are constructed using SDFs, connection pooling must be disabled for SDF. |
| 151 | === !DataConnectionPoolSize ===#ServerDataConnectionPoolSize |
| 152 | Pooled connections allows the !MapGuide Server to reuse existing connections to FDO feature sources. Database connections are created once and reused for multiple requests. Typically, two connections per core is sufficient to obtain full utilization of the cores on the !MapGuide Server. Please note: Many FDO providers maintain schema for each connection. This increases the memory footprint as more connections are opened. |
| 153 | === !DataConnectionPoolSizeCustom ===#ServerDataConnectionPoolSizeCustom |
| 154 | Pooled connections can also be set on a per-provider basis. This can be used to increase the connection pool for specific providers, like databases, while leaving the other providers alone. See [#ServerDataConnectionPoolSize DataConnectionPoolSize] for tuning considerations. |