OK.
This means that the best-case of migrating now to a newer version would be that
we would "only" loose one second per WMS request instead of 3 seconds per WMS
request... This is a significant improvement... if the behavior is the same in
our environment... but nonetheless it stays a very suboptimal situation.
Hopefully you find the time to have a look into the code to check if it is
possible to optimize these issues away...
Pieter
Van: [email protected] [mailto:[email protected]] Namens Andrea Aime
Verzonden: vrijdag 25 oktober 2013 14:43
Aan: Pieter Roggemans
CC: [email protected]
Onderwerp: Re: [Geoserver-users] Oracle vector JNDI: bad performance due to 16
database calls per layer fetched
On Fri, Oct 25, 2013 at 2:40 PM, Pieter Roggemans
<[email protected]<mailto:[email protected]>>
wrote:
Ouch... the culprit shows up now in 2.3.4 as well... so upgrading won't solve
the problem... at best it will reduce the problem:
SELECT NULL AS table_cat,/n o.owner AS table_schem,/n o.object_name
AS table_name,/n o.object_type AS table_type,/n NULL AS remarks/n
FROM all_objects o/n WHERE o.owner LIKE :1 ESCAPE '/'/n AND o.object_name
LIKE :2 ESCAPE '/'/n AND o.object_type IN ('xxx', 'TABLE', 'VIEW',
'SYNONYM')/n ORDER BY table_type, table_schem, table_name/n
Is the above query only executed once per layer fetched in a WMS call? In our
case it is 3 times per layer...
I have dumped all the queries performed for one wms call over a sql view in my
previous mail.
So yes, it's happening once per call.
Can probably be optimized out with some caching, not 100% sure, some
investigation in the code would be needed
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
