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

[Andy Zhang]

You are right, it's topobase provider:-).
Yes. I will apply the patch to the 2.4 branch, too.

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:24 PM
To: MapGuide Internals Mail List
Subject: Re: [mapguide-internals] PATCH: Ticket#1998 - Fdo connection manager enhancement

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