[Geoserver-users] geoserver WMS performance issue

GeoServer GeoServer User
1

Hi Everybody,

I am using geoserver 2.8.3 with Oracle NG (JNDI) datasource. i have an SQL View based wms layer.

I noticed that at org.geoserver.catalog.ResourcePool.java (line 929 ) there is an internal check witch queries tha database at every WMS request.

the select is the following :

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;

Can somebody tell me why this query is running at every WMS request. Is a name

collision detection with database objects needed at every WMS request ? because i thing this is a performance issue and a bug.

Or maybe i missing something …

Thanks for Help,

Kiss Attila

2

here is the solution:
create an empty "all_objects" table in the same schema as the geoserver to
Oracle db connection; this table will become a facade table for the
nonsensical call, bypassing the actual "all_objects" system view
e.g.:
create table <your geoserver login user>.all_objects
as
SELECT
         o.owner,
         o.object_name,
         o.object_type
    FROM all_objects o
   WHERE
1 = 0
;

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/geoserver-WMS-performance-issue-tp5270142p5309932.html
Sent from the GeoServer - User mailing list archive at Nabble.com.