Thanks, Andrea, that sounds like the cause. We'll upgrade and see if the
problem goes away.
On Tue, Sep 1, 2015 at 11:25 PM, Andrea Aime <[email protected]>
wrote:
> On Wed, Sep 2, 2015 at 1:21 AM, Martin Davis <[email protected]> wrote:
>
>> We've run some DB logging on the map requests.
>>
>> One of the causes of the slowdown for no schema is this query:
>>
>> SELECT NULL AS table_cat,
>> o.owner AS table_schem,
>> o.object_name AS table_name,
>> o.object_type AS table_type,
>> NULL AS remarks
>> FROM all_objects o
>> WHERE o.owner LIKE :1 ESCAPE '/'
>> AND o.object_name LIKE :2 ESCAPE '/'
>> AND o.object_type IN ('xxx', 'TABLE', 'VIEW', 'SYNONYM')
>> ORDER BY table_type, table_schem, table_name
>>
>> If no owner is specified this returns 38K rows, as opposed to about 240
>> when owner is given.
>>
>> I'm not totally sure what this is doing, but I suspect checking for
>> Primary Key info?
>>
>> And why is this being run on each MapRequest ?
>>
>> Funnily, we have 2.6.3 running in a different setup, and it doesn't seem
>> to be issuing any of these queries - just the data query. I can't see any
>> config difference that would cause this.
>>
>
> Maybe not so funny, I remember of a major performance regression in JDBC
> stores in 2.6.0,
> indeed it was very slow against spatial databases, see the 2.6.1 release
> notes:
> http://blog.geoserver.org/2014/11/18/geoserver-2-6-1-released/
>
> Discussion here:
>
> http://osgeo-org.1560.x6.nabble.com/Severe-slowdown-in-ContentDataStore-in-12-x-and-trunk-td5167030.html
>
> To avoid this kind of issue, besides more review, which never hurts but
> requires more staff, we'd need
> continuous performance testing and comparison against production sized
> databases, something
> I've been proposing on and off for several years, but that never got the
> resourcing it needs to make it happen.
>
>
>
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
