Hi, I use GeoServer 2.1 against a postgis table (postgres) which holds lots of geometry points.
These points, when added to the table, are grouped into groups of 500 by an integer id column to the table. i.e. First group of 500 point will all have id 1 and next id 2 and so on. In my sld used by my layer I use filter functions that will only filter out these 500 points at a time given an integer value filter on the id column. However when I look at the SQL queries, geoserver asks 500 queries to get each particle instead of using one query against the id column. Is there a way to get geoserver to ask for my own integer id column, like to hint it or similar to get better faster performance? ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
