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

[Andy Zhang]

Hi Zac,

It's a provider developed by Autodesk, which is used to connect Oracle database.  

Best Regards
Andy

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Monday, May 21, 2012 3:08 PM
To: MapGuide Internals Mail List
Subject: Re: [mapguide-internals] PATCH: Ticket#1998 - Fdo connection manager enhancement

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
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals