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

[Hallgren Johan E]

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
___________________________________

Johan Hallgren

 
WM-data
Pelle Bergs backe 3
Box 1938, 791 19 Falun
Tel (och mobil): 023-547 46 (int: +46-2354746)
johan.e.hallgren at wmdata.com <mailto:johan.e.hallgren at wmdata.com> 
http://www.wmdata.se <https://webaccess.wmdata.com/exchweb/bin/redir.asp?URL=http://www.wmdata.se/> 

________________________________

Från: Andreas Albarello [mailto:andreas.albarello at territoriumonline.com]
Skickat: må 2007-05-07 12:25
Till: Hallgren Johan E
Kopia: MAPSERVER-DEV at LISTS.UMN.EDU
Ä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.
>

Johan,

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 territoriumonline.com
web:   www.territoriumonline.com
--------------------------------------------------------------------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20070507/3f6ccf27/attachment.html