I am in the process of executing some performance tests against an
application using Geoserver v 2.0.2. Geoserver is configured with 5
Stores and 190 Layers (1 Workspace). Within these 5 stores there is a
total of 438 table or view objects, but only those 190 are configured
within Geoserver.
When I run my performance test, the CPU usage on the Oracle database
that hosts all 5 stores is very high. Some investigation of the
database revealed that one single query was run over 4,000 times (in
roughly the one hour the test was running) and each execution took
almost 1.5 seconds.
The query is...
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')
ORDER BY table_type, table_schem, table_name
I was wondering if perhaps I haven't configured Geoserver optimally
for caching? I am not sure why this query would need to be run so
many times or if there is some way to cache the results to limit the
number of times it needs to run.
Any advice or insight is appreciated.
- Sarah
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
