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

[Zac Spitzer]

what's the TB provider?

On Mon, May 21, 2012 at 5:06 PM, Andy Zhang <Andy.Zhang at autodesk.com> wrote:
> 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
> _______________________________________________
> mapguide-internals mailing list
> mapguide-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-internals



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168