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
