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, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF, http://osgeo.org

Reply via email to