[Geoserver-users] Geoserver - Oracle SDO - Performance

[diana2 <diana.cupelli@gm...>]

Hi,
I've deployed Geoserver 1.5.2 on Oracle OC4J 10.1.2 with some customization.
Now, I've performance problem opening viewer map...

We use Oracle SDO with Italy regions and provinces (table are very small ---
few Thousands of records...)

Any suggestion?

Thanks
Diana
-- 
View this message in context: http://www.nabble.com/Geoserver---Oracle-SDO---Performance-tp14370192p14370192.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Re: [Geoserver-users] Geoserver - Oracle SDO - Performance

[Andrea Aime <aaime@op...>]

diana2 ha scritto:
> Hi,
> I've deployed Geoserver 1.5.2 on Oracle OC4J 10.1.2 with some customization.

Hum, can you share with us the customization tips so that they can be
added to the OC4J page? If anybody else attempts to deploy in that 
container he won't have to go thru the same pain.

> Now, I've performance problem opening viewer map...
> 
> We use Oracle SDO with Italy regions and provinces (table are very small ---
> few Thousands of records...)
> 
> Any suggestion?

Upgrade to GeoServer 1.6.0, it's faster. If you can, use a more recent 
java version (going from jdk 1.4.0 to jdk 1.6.0 more than doubles 
performance by itself, see this presentation:
http://www.foss4g2007.org/presentations/view.php?abstract_id=120).

Also, what is the context of that slowness? Local usage (actual
map generation slow) or remote usage (big png files generated that
take time to travel over then net)?

Other than that, we are aware that Oracle datastore is not performing
at the best of its possibilities but there is no one maintaining and
improving it. We can try to do that, but only thru commercial support
channels (I have one option in mind that could improve performance,
but it would require the SDO_UTIL.TO_WKBGEOMETRY function that has
been introduced in Oracle 10.2).

Cheers
Andrea

Re: [Geoserver-users] Geoserver - Oracle SDO - Performance

[Andrea Aime <aaime@op...>]

Diana Cupelli ha scritto:
> Andrea,
> thanks for yor response...
> Oracle oC4J customizations are more than one:-) much of them are on OC4J 
> that have some bugs (10.1.2) risolved on 10.3.3... you can see on my 
> post on nabble.

Where? :)

> For performance, now i can't ugrada Geoserver (not now...).

Pity, it was the only easy suggestion I had...

> As you understood, my application is a javascript that use Oracle SDO 
 > without pgn and shp files.
> The application is very solw when the user open italy page... perhaps 
> this can be useful for you for help me ...

When the user opens the page? Is actually drawing the map that's slow,
getting the javascript needed in the browser or getting the image files
into the javascript client?
For the first there is not much I can do, for the javascript one, it
depends on how the client is made, optimized version of common
javascript libraries (OL, MapBuilder) do exist that are made up of a 
single file stripped file that downloads faster that the many single
files the development oriented sources are made of.
If instead is the map itself that downloads slow, maybe you should
try png8 output format or use paletted images (some more
information here: 
http://docs.codehaus.org/display/GEOSDOC/Paletted+images+tutorial).

Hope this helps
Cheers
Andrea

Re: [Geoserver-users] Geoserver - Oracle SDO - Performance

[diana2 <diana.cupelli@gm...>]

the problem appear whne we load tha map

layers_ref = new OpenLayers.Layer.WMS(
"fidi:GEO_VOLUMI_AZIENDALI_P", hostGeoServerWms, //GEO_VOLUMI_AZIENDALI_R
{
srs: 'EPSG:4326',
width: '500',
styles: layers_style,
height: '500',
layers: layers_name, 
//format: 'image/png', tiled: 'true', tilesOrigin :
"263422.83129139734,3869554.1625" 
format: 'image/png', tiled: 'true', tilesOrigin :
"263422.83129139734,3964954.1625" 
}, 
{maxExtent: bounds, maxResolution: 5528.452832031251, projection:
"EPSG:4326"} 
); 
map.addLayer(layers_ref);










diana2 wrote:
> 
> Hi,
> I've deployed Geoserver 1.5.2 on Oracle OC4J 10.1.2 with some
> customization.
> Now, I've performance problem opening viewer map...
> 
> We use Oracle SDO with Italy regions and provinces (table are very small
> --- few Thousands of records...)
> 
> Any suggestion?
> 
> Thanks
> Diana
> 

-- 
View this message in context: http://www.nabble.com/Geoserver---Oracle-SDO---Performance-tp14370192p14373909.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Re: [Geoserver-users] Geoserver - Oracle SDO - Performance

[Andrea Aime <aaime@op...>]

diana2 ha scritto:
> the problem appear whne we load tha map
> 
> layers_ref = new OpenLayers.Layer.WMS(
> "fidi:GEO_VOLUMI_AZIENDALI_P", hostGeoServerWms, //GEO_VOLUMI_AZIENDALI_R
> {
> srs: 'EPSG:4326',
> width: '500',
> styles: layers_style,
> height: '500',
> layers: layers_name, 
> //format: 'image/png', tiled: 'true', tilesOrigin :
> "263422.83129139734,3869554.1625" 
> format: 'image/png', tiled: 'true', tilesOrigin :
> "263422.83129139734,3964954.1625" 
> }, 
> {maxExtent: bounds, maxResolution: 5528.452832031251, projection:
> "EPSG:4326"} 
> ); 
> map.addLayer(layers_ref);

Hmm... no, this does not ring a bell. Maybe you can try
removing the tiled and tilesOrigin params and see if it
works any better.
Then try to use format: 'image/png8'. If none of these
help, I don't know what it might be...

Cheers
Andrea