On Fri, Oct 25, 2013 at 2:40 PM, Pieter Roggemans <
[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
