Thanks Andrea - I am going give your suggestions a try.
Regards
Pierre
-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: Thursday, September 06, 2007 11:28 AM
To: Le Roux, Pierre
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GS.1.5.3 - Oracle
Le Roux, Pierre ha scritto:
Forum ..
Let's try again ...apologies for the sticky fingers post earlier
I have set up GS 1.5.3 with Oracle 10gR2 and I am noticing that
performance seems slow - when generating the wms tiles - but
especially
when executing a GetFeatureInfo request. The oracle spatial feature
class contains only about 300 000 polygons with their associated
attributes - spatial indices and primary keys all exist and table
stats
are up to date.
Has anyone else seen a performance issue with oracle ? If so , I
would
appreciate hearing from you. If not - hints as to what I may be doing
wrong will really be helpful.
When generating the WMS tiles, I can't do much about it... Oracle jdbc
driver is doing a very poor job carrying geometries around, usually
most of the time is spend loading data. I have some optimization in
mind, but it would work only with 10.2 (I need the function that
converts a geometry in wkb format).
As for the GetFeatureInfo being slow, known problem, already fixed btw:
http://jira.codehaus.org/browse/GEOS-1313
You can grab a nightly of 1.5.x (soon to become 1.5.4) here:
http://geo.openplans.org/nightly/1.5.x/
Oh, we did some serious performance work in 1.6.x, Oracle datastore
was not involved directly (optimized only shapefile and postgis) but
some speedups are datastore independent. You can also grab
a GeoServer 1.6.x nightly from
http://geo.openplans.org/nightly/trunk/ and give it a spin.
More performance hints here:
http://docs.codehaus.org/display/GEOSDOC/4+GeoServer+in+Production+Envir
onment
If you use trunk nightly and you can live without antialiasing,
I suggest you add "&format_options=antialias:none" to your GetMap
requests, you'll get faster rendering and (much) smaller returned files.
Otherwise, take a look at
http://docs.codehaus.org/display/GEOSDOC/Paletted+images+tutorial to get
at least smaller returned files.
Hope this helps
Cheers
Andrea