RE: [Geoserver-users] GeoServer Performance

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&quot;
  xmlns:wfs="http://www.opengis.net/wfs&quot;
  xmlns:ogc="http://www.opengis.net/ogc&quot;
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;
  xmlns:gml="http://www.opengis.net/gml&quot;&gt;

  <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&quot;&gt;
    <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/

Guys,

I noticed while running some fairly simple queries on
GIST table with a number of filters that two database
accesses are required. The first one looks like it
either prepares a data type conversion, by using a
AsText() method and the second one looks like the
query proper. What is going on here. The most
important aspect of performance is of course to have
in order the fewest:

1) Network Round Trips
2) Database hits
3) Disk access hits
4) Page faults

So clearly this is a concern right off the bat.

Bradley

--- dblasby@anonymised.com wrote:

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&quot;
  xmlns:wfs="http://www.opengis.net/wfs&quot;
  xmlns:ogc="http://www.opengis.net/ogc&quot;

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;

  xmlns:gml="http://www.opengis.net/gml&quot;&gt;

  <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&quot;&gt;

  

<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/

-------------------------------------------------------

SF.Net email is Sponsored by the Better Software
Conference & EXPO
September 19-22, 2005 * San Francisco, CA *
Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects
& Teams * Testing & QA
Security * Process Improvement & Measurement *
http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/geoserver-users

__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html