[Mapserver-dev] RE: postgis db connection caching...

[Paul Ramsey]

Given thought to and implemented.
  Jan Hartmann committed a per-session caching scheme about 6 months 
ago. Layers which use the same connection can pull the handle from a 
connection pool.
  Read through the SDE layer to see it in action. Currently it is only 
used by the SDE layer type. We may add it to the PostGIS section, but 
frankly connection overhead is very small for PgSQL.
  As far as mapscript goes, the idea system would be one where handles 
could be passed into mapscript from an external application. But that 
could be really hard to do in a way which binds nicely with multiple 
languages.
Paul

Chris G. Nicholas wrote:
> Before I attempt shameless experimental hacking, has anyone given
> thought to caching db connections, both within the same mapfile
> across different layers, and in general within mapscript
> applications?
>

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_