More of pooling, mapquery.c

[Andreas Albarello]

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
--------------------------------------------------------------------