Performance hints please

[Frank Warmerdam]

Ed McNierney wrote:
> Stephen -
> 
> "The amount of geometry involved is so small, the bottleneck has to be
> the raster processing"
> 
> That is a dangerous assumption.  Retrieving a small amount of data from
> a large, slow database server can take a long time - particularly if
> you're re-establishing the connection each time.
> 
> Are you using pooled persistent connections to PostGIS with a FastCGI
> MapServer?

Ed / Stephen,

In my experience connection cost for PostGIS is very very modest and
FastCGI does not offer a worthwhile advantage for PostGIS.

However, the general statement about dangerous assumptions is right on!

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF, http://osgeo.org