On Fri, Oct 25, 2013 at 10:27 AM, Pieter Roggemans <
[email protected]> wrote:
> In the overview above you see that 2), 5) and 6) is the same query being
> executed 3 times per layer... so 30 times in our average case. If there is
> a "SCHEMA" defined (any) in the JNDI data store, this query takes 0.1
> second per execution in our config... if not... +- 1 second per execution.
> This means that best-case this query accounts for 0.1 * 30 calls = 3
> seconds added time for each WMS request... which means 66% of the time
> because our average WMS request takes 4.5 seconds.
>
Btw, the 0.1s per query caught my eye. I have a small Oracle table in a
vanilla Oracle XE installed on Ubuntu 12.04 64 bit,
that I'm displaying fully (500 multilines), and I did a quick performance
check making 1000 wms requests with "ab" (ApacheBench), using a single
thread.
Here is the result:
Requests per second: 14.24 [#/sec] (mean)
Time per request: 70.203 [ms] (mean)
So, on my machine, GeoServer does 4 Oracle queries, paints the map, encodes
the result in PNG in less time than it takes for you to run a single SQL
statement?
That's odd, my desktop has a 3.5 years old core i7 860. I mean, I
understand in your case there will be a network in between, but still...
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
-------------------------------------------------------
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
