[Geoserver-devel] [jira] Created: (GEOS-1313) Use the DB for filtering object for GetFeatureInfo

Use the DB for filtering object for GetFeatureInfo
--------------------------------------------------

                 Key: GEOS-1313
                 URL: http://jira.codehaus.org/browse/GEOS-1313
             Project: GeoServer
          Issue Type: Improvement
          Components: WMS
    Affects Versions: 1.5.3
            Reporter: Patrick Valsecchi
            Assignee: Andrea Aime

I have an PostGIS layer with around 6000 entries with quite complex polygons. I use WMS for accessing my data.

When I do a GetFeatureInfo, it takes a lot more time than just the GetMap (around 2 seconds). After investigation I found out that GeoServer is reading my whole database each time I do a GetFeatureInfo and does the filtering in Java.

You should use the SQL capabilities (where clause with a BBOX matching) instead. That would greatly improve the performances.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira