Hi all,
currently I am evaluating the GeoServer according to functionality and performance issues.
While executing some DELETE Requests to a PostGIS datastore I have to wait unexpectly long for a response.
The postmaster process runs with 100% on an AMD Opteron 2.2 GHz, but a single
DELETE request takes still about 1200 ms. By the way, INSERTs are performed well (<20ms).
Am I doing anything wrong? By which means this process can be accelerated?
Here is my XML-file which is sent by HTTP Post to the server in a local network:
<wfs:Transaction service="WFS" version="1.1.0"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:topp="http://www.geoserver.org/topp"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ogc="http://www.opengis.net/ogc"
xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd http://www.openplans.org/topp http://localhost:8080/geoserver/wfs/">
<wfs:Delete typeName="topp:assessmentpoint">
<ogc:Filter>
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:damagevalue</ogc:PropertyName>
<ogc:Literal>70.4</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:comment</ogc:PropertyName>
<ogc:Literal>2006-01-01;insert WFS test</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:damagecaseid</ogc:PropertyName>
<ogc:Literal>5161</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:And>
</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>
Thanks in advance,
Sebastian
_______________________________________________________________________
Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220
Could you put the logging level at FINE and check the logs for the sql statement that's being executed for DELETE's? Then try out that statement in postgis directly? And send us what the sql statement is.
My guess might be that indexes on the properties you're filtering on could help. Though there could be something off in the code, if we're not passing a good sql statement back to the db. Also what version of GeoServer and PostGIS are you using?
thanks,
Chris
Sebastian Paasche wrote:
Hi all,
currently I am evaluating the GeoServer according to functionality and performance issues. While executing some DELETE Requests to a PostGIS datastore I have to wait unexpectly long for a response.
The postmaster process runs with 100% on an AMD Opteron 2.2 GHz, but a single DELETE request takes still about 1200 ms. By the way, INSERTs are performed well (<20ms). Am I doing anything wrong? By which means this process can be accelerated? Here is my XML-file which is sent by HTTP Post to the server in a local network:
<wfs:Transaction service="WFS" version="1.1.0"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:topp="http://www.geoserver.org/topp"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ogc="http://www.opengis.net/ogc"
xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd http://www.openplans.org/topp http://localhost:8080/geoserver/wfs/">
<wfs:Delete typeName="topp:assessmentpoint">
<ogc:Filter>
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:damagevalue</ogc:PropertyName>
<ogc:Literal>70.4</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:comment</ogc:PropertyName>
<ogc:Literal>2006-01-01;insert WFS test</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>topp:damagecaseid</ogc:PropertyName>
<ogc:Literal>5161</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:And>
</ogc:Filter> </wfs:Delete>
</wfs:Transaction>
Thanks in advance,
Sebastian
_______________________________________________________________________
Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4005,4694aebb238071804284693!