[mapserver-users] long-running postgres queries initiated by mapserver

[mattmendick]

Hi All-

I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using
postgres as the data storage container, and mapserver is primarily serving
WFS requests.  Sometimes, people do WFS queries that take a very long time
(searching for "virginia" on a nation-wide layer) and eventually postgres
will return with the result after a long time (hours later), however the
client has cancelled the WFS request.  Is there any way for mapserver to
know that the client has cancelled the http request, and it can therefore
stop the DB query to postgres?  I tried using persistent and non-persistent
connections with this:

PROCESSING "CLOSE_CONNECTION=DEFER"

but that didn't change the behavior.

Thanks a lot!
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/long-running-postgres-queries-initiated-by-mapserver-tp5855539p5855539.html
Sent from the Mapserver - User mailing list archive at Nabble.com.