[mapserver-users] Limiting the execution time of mapserver

[Andy Colson]

On 6/22/2010 9:57 AM, mattmendick wrote:
>
> I have a WFS service running with a large layer in it (nationwide) on
> mapserver. The interface that consumes it exposes a text search option where
> users can search on the layer, using the PropertyIsLike filter. If someone
> searches for something very broad, like "smith" postgres and mapserver go a
> bit insane. First postgres does the large query, and returns the response
> after a few minutes to mapserver, which proceeds to balloon to 85% of the
> memory (the machine has 7 gigs).  Is there any way to stop mapserver from
> completing any queries that last more than X seconds?
>
> Thanks a lot!

Do you want all the smiths?  You could add a 'limit 100' to the sql so 
mapserver wouldnt have as much data to chew on...

-Andy