More detailed log file (with sql-statements):
http://geoserv.weichand.de/tmp/sqllog.txt
Runtime of the count-statement(s) on huge tables/views (~10.000.000
features)?
Needed for paging?
Am 15.02.2013 14:47, schrieb Jürgen Weichand:
Hi Andrea,
it's a simple feature setup. I also didn't measure the first request.
Example:
n > 1
Request n + 0 => WFS 1.0 < 1s
Request n + 1 => WFS 1.0 < 1s
Request n + 2 => WFS 1.1 40 - 45 s
Request n + 3 => WFS 1.1 40 - 45 s
Request n + 4 => WFS 2.0 95 - 105 s
Request n + 5 => WFS 2.0 95 - 105 s
Request n + 6 => WFS 1.0 < 1s
Best regards
Juergen
Am 15.02.2013 14:27, schrieb Andrea Aime:
On Fri, Feb 15, 2013 at 11:03 AM, Jürgen Weichand
<[email protected]
<mailto:[email protected]>> wrote:
Hello List,
we've discovered a performance difference between WFS 1.0, WFS
1.1 and
WFS 2.0 bbox queries.
A good 2 times performance difference is expected since the GML2
encoder is
way more efficient than the GML 3.x ones, but what you're observing
is not.
Did you just measure the first request? That one has to do complex setups
which are then cached, subsequent ones ones should be significantly
faster
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
