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

[Zac Spitzer]

ah ok, topobase right?

I think I have might have seen this problem with the king oracle
provider as well

If so, I have a client using MGE where this is quite noticeable under load

when you commit this, can you apply to the 2.4 branch? Jackie and I are
doing lots of testing at the moment and we can provide feedback

z

On Mon, May 21, 2012 at 5:18 PM, Andy Zhang <Andy.Zhang at autodesk.com> wrote:
> 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
>
> _______________________________________________
> 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