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 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
