[mapguide-internals] PATCH: Ticket#1998 - Fdo connection manager enhancement

[Andy Zhang]

Hi all,

Here is a patch ready for your review.
http://trac.osgeo.org/mapguide/ticket/1998

This patch made some changes on FdoConnectionManager<http://trac.osgeo.org/mapguide/wiki/FdoConnectionManager> to improve the performance of PerCommandThreaded/MultiThreaded<http://trac.osgeo.org/mapguide/wiki/PerCommandThreaded/MultiThreaded> provider.
Take FDO TB provider as example, it is a PerCommandThreaded<http://trac.osgeo.org/mapguide/wiki/PerCommandThreaded> provider. Suppose there are 2 operation requests at the same time. Currently, the 2 requests will share one connection. In our tests, it is about 30% slower than 2 requests 2 connections.
This patch changes the behavior to open a new connection if the connection pool of this provider is not full. And reuse connection if connection pool is full. This change has no impact on providers which thread model is not PerCommandThreaded/MultiThreaded<http://trac.osgeo.org/mapguide/wiki/PerCommandThreaded/MultiThreaded>.

Thanks
Andy