I suspected that... sigh.

Could you please create a jira issue about this? 
<http://jira.codehaus.org/browse/GEOT> component: data-arcsde, asignee: me.

There's a difficult compromise to take wrt ArcSDE raster performance. Right now 
it's optimized for no reprojection and streaming. Meaning it takes advantage of 
the rasters pyramid of tiles to conserve server resources while at the same 
time being able of serving large images.
The other two options are:
 - building the image in-memory, of the requested size. This can easily lead to 
out of memory exceptions and very poor performance
 - Using the JAI tile cache: hard to optimize, in the long run/under 
concurrency can bloat memory or incur in high synchronization costs, affecting 
performance.

Second option seems like a better compromise though, as long as its tunable.

The underlying reason is that having to fetch the raster tiles from the 
database is not as a cheap operation as it would be by reading directly from 
disk (like for a tiled geotiff with overview). The ArcSDE plugin needs to 
execute a database query that'll fetch all the tiles needed and traverse them 
(like if it were a JDBC resultset). Problem is when reprojection is applied, 
the JAI operation chain tends to request for tiles in non consecutive order, 
forcing the execution of more database queries, as the "resultset" can't be 
rewinded. Using the JAI tile cache more aggressively alleviates the need for 
extra database queries, that are expensive.

Building the requested image fully in memory instead of streaming is fast as 
long as the image size is small. But one can easily request for the whole 
raster with WCS, and that just won't work.

That's the explanation, now we should get to a better compromise.

Thanks for reporting the problem. Would you like to be a tester?

Cheers,
Gabriel
On Aug 24, 2010, at 4:47 AM, Miloslav Kmeť wrote:

> We have tested on several servers GEOSERVER 2.x with ArcSDE 9.3.1 rasters 
> reprojection of
> WMS service.
> 
> It's extremly slow.
> 
> Can you help?
> 
> Testing url:
> 
> http://geo.enviroportal.sk/geoserver/sazp/zakladna_mapa_10000/wms - slow
> 
> http://geo.enviroportal.sk/geoserver/sazp/dmr3/wms  - timeout
> 
> http://geo.enviroportal.sk/geoserver/sazp/IMA_2000/wms - mostly timeout
> 
> Same data in WMS - ArcGis server works for reprojection fast.
> 
> Thank you
> 
> -- 
> Miloslav Kmeť
> 
> ------------------------------------------------------------------------------
> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
> Be part of this innovative community and reach millions of netbook users 
> worldwide. Take advantage of special opportunities to increase revenue and 
> speed time-to-market. Join now, and jumpstart your future.
> http://p.sf.net/sfu/intel-atom-d2d
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

Gabriel Roldan
[email protected]
Expert service straight from the developers


------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to