A few people were asking about geoserver performance. I ran a few
tests.
For this query:
<?xml version="1.0" encoding="UTF-8"?>
<wfs:GetFeature service="WFS" version="1.0.0"
outputFormat="GML2"
xmlns:topp="http://www.openplans.org/topp"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:gml="http://www.opengis.net/gml">
<Query typeName="tiger:poi">
<ogc:Filter>
<ogc:Intersects>
<ogc:PropertyName>the_geom</ogc:PropertyName>
<gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
<gml:coordinates>-74.0120840108419,40.708328015111306
-74.0115791437357,40.70883288221751</gml:coordinates>
</gml:Box>
</ogc:Intersects>
</ogc:Filter>
</Query>
</wfs:GetFeature>
Takes about 50-60ms on my crappy slow laptop to a shapefile.
Takes about 60-80ms on my crappy slow laptop to a postgis database
(running on the same machine).
NOTE:
*) this returns only one feature
*) the postgis database/shapefile is small, so I imagine that it has
the disk pages all in memory so query time is, basically, instant.
*) I'd expect 2-4* performance on a modern server vs my laptop.
*) There's probably quite a few improvements to be made to
geotools/geoserver code to make this quicker. I'd expect you could get
25% to 100% faster if you spent a day or 2 profiling.
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/