After upgrading to GeoServer 2.3.3 (from version 2.1.1) a GetFeature request is
taking several minutes to complete. When using version 2.1.1 the same request
took 300-500ms which is already a little bit slow (definitely for our use
case). Certainly if you compare with the time needed to render a map, which is
lightning fast!
I have monitored the queries that were executed and in the 2.3.3 version it's a
complete other query (using paging). I have no idea why.
2.3.3 query (which takes 23 seconds to execute on sql server 2008):
SELECT *
FROM (SELECT "MI_Id","GeoNode".STAsBinary() as
"GeoNode","node_type","owner","system_type","asset_id","MI_Style","uid","user_text_3",
ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) AS _GT_ROW_NUMBER
FROM "dbo"."ViewIPUT"
WHERE "GeoNode".Filter(geometry::STGeomFromText('POLYGON
((151985.91214561 211273.46959495, 151985.91214561 211283.84555244,
151996.2881031 211283.84555244, 151996.2881031 211273.46959495, 151985.91214561
211273.46959495))', 31370)) = 1
) AS _GT_PAGING_SUBQUERY
WHERE _GT_ROW_NUMBER <= 10
2.1.1 query (which takes <30ms to execute):
SELECT "MI_Id",CAST("GeoNode".STSrid as VARCHAR) + ':' + "GeoNode".STAsText()
as
"GeoNode","node_type","owner","system_type","asset_id","MI_Style","uid","user_text_3"
FROM "dbo"."ViewIPUT"
WHERE "GeoNode".Filter(geometry::STGeomFromText('POLYGON ((150397.35305405
211179.04838181, 150397.35305405 211199.80029678, 150418.10496902
211199.80029678, 150418.10496902 211179.04838181, 150397.35305405
211179.04838181))', 31370)) = 1
Is it possible to disable paging? Or increase performance? Maybe I did
something wrong when upgrading to this version? Although I did nothing more
than just copying the data directory from the 2.1.1 version to the 2.3.3
version.
________________________________
Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> |
Twitter<https://twitter.com/aquafinnv> |
YouTube<http://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee> |
LinkedIN<http://www.linkedin.com/company/aquafin/products>
Disclaimer: zie www.aquafin.be<http://www.aquafin.be> P Denk aan het milieu.
Druk deze mail niet onnodig af.
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
