On Fri, Oct 25, 2013 at 11:55 AM, Andrea Aime
<[email protected]>wrote:
> Hi,
> I've just tried out with a 2.3.4 I was working with, I only see 4 queries
> for each of my WMS requests, a line layer that I've renamed compared to the
> raw table name to have a nicer looking name:
>
> 1) SELECT GEOMETRY as GEOMETRY FROM GEOSERVER.GRAFO_EXP WHERE
> SDO_FILTER(GEOMETRY, :1, 'mask=anyinteract querytype=WINDOW') = 'TRUE'
> 2) select 1 from dual
> 3) SELECT info from "GEOSERVER".MDRT_6757$ where rowid = :rid
> 4) select count(*) from mdsys.geodetic_srids where srid = :srid
>
> As you know 1 and 2 cannot be avoided (well 2) can be removed by disabling
> connection validation)
> 3 is weird, must be generated by the jdbc driver but I have no idea why
> and what it is about
>
Ok, now I know what that is, it's an access to the spatial index. It may
well be it cannot be removed, but this one
too requires a bit more investigation.
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
