[mapserver-users] PROCESSING : Connection to Postgis (defer or always)

[Carlos Ruiz]

Milad,
You can use the directive PROCESSING "CLOSE_CONNECTION=DEFER" when you have several PostGIS layers to be rendered to reduce the time because of opening the database connections. This means that once the database connection is established for the first time, it will be shared for all the layers which use the same connection string (same host, database, user and password). This takes less time consuming than opening and closing a database connection for each layer (PROCESSING "CLOSE_CONNECTION=ALWAYS").
Cheers

      From: milad nidal <miladnidal2604 at gmail.com>
 To: MapserverList OSGEO <mapserver-users at lists.osgeo.org> 
 Sent: Wednesday, January 25, 2017 11:39 AM
 Subject: [mapserver-users] PROCESSING : Connection to Postgis (defer or always)
   
I have 100layers with data connection to postgis (10 mapfiles). In the mapserver (v. 7) documentationthere is a point (which I do not understand) regarding the PROCESSING "CLOSE_CONNECTION=ALWAYS"OR PROCESSING "CLOSE_CONNECTION=DEFER"Now if I doa tile cache for all the layer together.. Is-it better to use Defer or always.Actually when we should use always and when we should use defer?Thanks for asimple explanation 
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170125/52ec8e4a/attachment.html>