SV: [UMN_MAPSERVER-DEV] More of pooling, mapquery.c

Hallgren Johan E jhhal at WMDATA.COM
Mon May 7 13:59:13 EDT 2007

Hello Andreas,
I'm using at least ver 4.10.1 of MapServer. How do I check if the connection pooling is up and working? Do I have to tell Mapserver to use pooling?

Johan Hallgren

Pelle Bergs backe 3
Box 1938, 791 19 Falun
Tel (och mobil): 023-547 46 (int: +46-2354746)
johan.e.hallgren at <mailto:johan.e.hallgren at> <> 


Från: Andreas Albarello [mailto:andreas.albarello at]
Skickat: må 2007-05-07 12:25
Till: Hallgren Johan E
Ämne: Re: [UMN_MAPSERVER-DEV] More of pooling, mapquery.c

Hallgren Johan E wrote:
> Hello again,
> I have made a test with the following code with extremely good
> performance. I have only tested this specific call, but couldn't the
> concept be implemented in other functions as well? As I see it, it will
> implement the Connection pool between mapscript calls.


this shouldn't be necessary unless your connection pooling is not
working correctly. Mapserver's connection pool already successfully
shares connections having the same connection string within the same
thread. The msLayerOpen call in your example should therefore not be
opening another connection to the database.

If it indeed does, you might want to check if your connection pooling is
up and working, if it is active on that layer, that you have a fairly
recent Mapserver/Mapscript build and that the subsequent requests come
from within the same thread.

Best regards,
Andreas Albarello
Analysis & SW Development

Territorium Online srl/GmbH
Via Buozzi/Buozzistraße 12 - I 39100 Bolzano/Bozen
email: andreas.albarello at

-------------- next part --------------
An HTML attachment was scrubbed...

More information about the mapserver-dev mailing list