Hi David, unfortunately I am under a heavy load this week. Could you create a JIRA ticket for geotools and attach a patch for 2.7.x. (Would be happy if you can attach a patch for trunk too). I would commit after the test pass.
Christian Zitat von David Adler <[email protected]>: > Hi Andrea - thanks for the quick response. > > DB2 already has the sql function to do this and the DB2 support for > GeoTools has this capability as well. > > How does it get added to the GeoServer GUI and the value set so that it > can be used by the DB2 store? > > On 3/22/2012 9:53 AM, Andrea Aime wrote: >> On Thu, Mar 22, 2012 at 2:23 PM, David Adler <[email protected] >> <mailto:[email protected]>> wrote: >> >> The PostGIS data store interface allows one to select "Loose bbox" but >> this isn't available for DB2. >> >> The "Loose bbox" can improve query performance by a factor of 2-5 and >> CPU utilization by a factor of 10. >> >> How can this get added? >> >> >> Loose bbox in postgis uses a sql function (st_estimated_extent) >> that queries the root >> of the spatial index instead of accessing the whole data set: >> http://postgis.refractions.net/documentation/manual-1.3/ch06.html >> >> To implement something similar in DB2 I guess you need an equivalent >> sql function for DB2 (and then write code to support it) >> >> 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 339 8844549 >> >> 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 >> >> ------------------------------------------------------- > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
