On Tue, Feb 15, 2011 at 2:23 PM, Tomas Pettersson <[email protected]> wrote: > > 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?
Filter functions are always evaluated in memory in 2.0.2, however that should not result in 500 queries, unless it's the function itself that runs the query, if it does in fact it will be called up once for each returned feature and that will result in a separate query per feature. Could you share the SLD and show what the functions you're talking about are doing? Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ 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
