<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 11/09/2012 09:16 AM, Eichner,
Andreas - SID-NLKM wrote:<br>
</div>
<blockquote
cite="mid:56B587E7C40D2F43B54FDC1BA897AC6D037AF454@KS-EVS1.smi.sachsen.de"
type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Once the request is done the the connection
will be closed.
</pre>
</blockquote>
<pre wrap="">I thought that setting allows to open the db connection only
once , keep it open until all layers data are read and will
prevent closing and opening connections in between layers ?
</pre>
</blockquote>
<pre wrap="">
That's right. You can query more than one layer per GetMap request and
MapServer will open the database connection only once for all layers
involved. But once the request is done AFAIK the database connection
will be closed. </pre>
</blockquote>
If you think that the time needed to establish the connection to
PostgreSQL is relevant in your case, you might consider to use of a
connection pooler, like
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://wiki.postgresql.org/wiki/PgBouncer">http://wiki.postgresql.org/wiki/PgBouncer</a>.<br>
<blockquote
cite="mid:56B587E7C40D2F43B54FDC1BA897AC6D037AF454@KS-EVS1.smi.sachsen.de"
type="cite">
<pre wrap="">
</pre>
</blockquote>
(...)<br>
<blockquote
cite="mid:56B587E7C40D2F43B54FDC1BA897AC6D037AF454@KS-EVS1.smi.sachsen.de"
type="cite">
<pre wrap="">
HTH
_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
Peter<br>
<pre class="moz-signature" cols="72">--
Peter Hopfgartner
R3 GIS Srl - GmbH
web : <a class="moz-txt-link-freetext" href="http://www.r3-gis.com">http://www.r3-gis.com</a>
</pre>
</body>
</html>