Re: [Geoserver-users] Oracle vector JNDI: bad performance due to 16 database calls per layer fetched

Wed, 30 Oct 2013 10:36:49 -0700

For the validation query.... In a few days I'l be able to retest in 2.4.1



-------- Oorspronkelijk bericht --------
Van: Andrea Aime <[email protected]>
Datum:
Aan: Pieter Roggemans <[email protected]>
Cc: Jonathan Moules <[email protected]>,[email protected]
Onderwerp: Re: [Geoserver-users] Oracle vector JNDI: bad performance due to 16 database calls per layer fetched


On Wed, Oct 30, 2013 at 6:03 PM, Pieter Roggemans <[email protected]> wrote:

Hello,

Thanks for looking into this.

 

When I did my tests last year “Oracle NG” and “Oracle JNDI” gave the same results… but when I retested now on our current environment (geoserver 2.2.0 instead of 2.1.4) there are indeed significant differences between the two:

 

- Oracle JNDI (using an “SQL view” layer):

        - 16 calls to the database per layer, and query “SELECT NULL AS table_cat…” takes 0.1 second per execution

        - 8 out of the 16 calls it is the validation query or the JNDI connection pool

 

- Oracle NG (using an “SQL view” layer):

        - 2 calls to the database per layer:

                - the query getting the data

                - +- the data query but with an extra “where 1=0” appended

        - NO validation query, even though the “validation query” checkbox is enabled in the data store definition. Or is the “where 1=0” query the validation query?


It is not. No idea why it's not happening, I have it in my logs (from 2.3.x).
What's weird is that the JNDI one just sets up the connection pool in a different way... and also strange, its name should be "Oracle NG (JNDI)", not "Oracle JNDI"

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


-------------------------------------------------------
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to