On 23-10-14 16:57, Andrea Aime wrote: > n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde > We upgraded to 2.6.0 (and still doing fine :-) ), but Oracle layers > performance is much lower compared to 2.4.3 > > Can somebody help me with this, or confirm behaviour like this? > > Yes, we know, we have a fix. Can you try 2.6.x nightlies? > http://ares.boundlessgeo.com/geoserver/2.6.x/
Ouch, yes, that is better... see the log.txt attached. Good that it is fixed, should have test this here earlier :-( Any planning for a 2.6.1 release ? Thanks, Richard Duivenvoorde
GEOSERVER 2.6.0-nightly ======================= 2014-10-23 17:18:21,756 TRACE [ows.OWSHandlerMapping] - No handler mapping found for [/wms] 2014-10-23 17:18:21,756 DEBUG [ows.OWSHandlerMapping] - Mapping [/wms] to HandlerExecutionChain with handler [org.geoserver.ows.Dispatcher@5b57880a] and 1 interceptor 2014-10-23 17:18:21,757 INFO [geoserver.wms] - Request: getServiceInfo 2014-10-23 17:18:21,758 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,759 DEBUG [geotools.util] - CRSConverterFactory can be applied from Strings to CRS only. 2014-10-23 17:18:21,759 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,759 DEBUG [geotools.util] - CRSConverterFactory can be applied from Strings to CRS only. 2014-10-23 17:18:21,761 DEBUG [geoserver.ows] - Getting layers and styles from LAYERS and STYLES 2014-10-23 17:18:21,761 DEBUG [geotools.styling] - number of fts set 1 2014-10-23 17:18:21,762 DEBUG [geoserver.ows] - establishing polypaars2 style for nieuwegein:KAAS 2014-10-23 17:18:21,775 DEBUG [geoserver.wms] - setting up map 2014-10-23 17:18:21,776 DEBUG [wms.map] - setting up 1750x1255 image 2014-10-23 17:18:21,784 DEBUG [wms.map] - setting to transparent 2014-10-23 17:18:21,791 DEBUG [geotools.rendering] - Computed scale denominator: 187.55357142862127 2014-10-23 17:18:21,792 DEBUG [geotools.rendering] - Processing 1 stylers for http://www.nieuwegein.nl:KAAS 2014-10-23 17:18:21,792 DEBUG [geotools.rendering] - creating rules for scale denominator - 187,554 2014-10-23 17:18:21,793 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,793 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,793 DEBUG [geotools.util] - CRSConverterFactory can be applied from Strings to CRS only. 2014-10-23 17:18:21,793 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,793 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,794 DEBUG [geotools.rendering] - Expanding rendering area by 2 pixels to consider stroke width 2014-10-23 17:18:21,794 DEBUG [geotools.rendering] - Querying layer http://www.nieuwegein.nl:KAAS with bbox: ReferencedEnvelope[134090.74059499998 : 134182.85190500002, 448994.51183316734 : 449060.6356668327] 2014-10-23 17:18:21,795 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,795 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,795 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,795 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,796 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,796 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,797 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,797 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,798 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,798 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,798 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,798 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,799 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,799 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,799 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,800 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,800 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,800 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,801 TRACE [geotools.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 2014-10-23 17:18:21,801 TRACE [geotools.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation GeometryFactory. 2014-10-23 17:18:21,801 DEBUG [geotools.jdbc] - CREATE CONNECTION 2014-10-23 17:18:21,803 DEBUG [geotools.filter] - exporting PropertyName 2014-10-23 17:18:21,803 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,803 DEBUG [geotools.util] - CRSConverterFactory can be applied from Strings to CRS only. 2014-10-23 17:18:21,803 DEBUG [geotools.jdbc] - SELECT GEOM as GEOM FROM KAAS WHERE SDO_FILTER(GEOM, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' 2014-10-23 17:18:21,805 DEBUG [oracle.sdo] - Using layer SRID: 28992 2014-10-23 17:18:21,805 DEBUG [geotools.jdbc] - Setting parameter 1 as MDSYS.SDO_GEOMETRY(2003,28992,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(134090.74059499998,448994.51183316734,134182.85190500002,449060.6356668327)) 2014-10-23 17:18:21,806 DEBUG [geotools.jdbc] - 1 = POLYGON ((134090.74059499998 448994.51183316734, 134090.74059499998 449060.6356668327, 134182.85190500002 449060.6356668327, 134182.85190500002 448994.51183316734, 134090.74059499998 448994.51183316734)) 2014-10-23 17:18:21,811 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,811 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,811 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,812 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,812 DEBUG [geotools.jdbc] - CLOSE CONNECTION 2014-10-23 17:18:21,814 DEBUG [geotools.rendering] - Style cache hit ratio: 0.0 , hits 0, requests 1 2014-10-23 17:18:21,814 INFO [geoserver.wms] - Request: getMap Time = [] Filter = null Buffer = 0 Format = image/png Palette = null MaxFeatures = null Filters = null Env = {} Exceptions = SE_XML Angle = 0.0 RemoteOwsType = null RemoteOwsURL = null FormatOptions = {} Width = 1750 Height = 1255 Styles = [StyleImpl[ name=polypaars2]] Layers = [org.geoserver.wms.MapLayerInfo@bdea857b] Transparent = true SldBody = null Sld = null StyleUrl = null StartIndex = null SRS = EPSG:28992 Crs = PROJCS["Amersfoort / RD New", GEOGCS["Amersfoort", DATUM["Amersfoort", SPHEROID["Bessel 1841", 6377397.155, 299.1528128, AUTHORITY["EPSG","7004"]], TOWGS84[565.2369, 50.0087, 465.658, -0.40685733032239757, -0.3507326765425626, 1.8703473836067959, 4.0812], AUTHORITY["EPSG","6289"]], PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], UNIT["degree", 0.017453292519943295], AXIS["Geodetic longitude", EAST], AXIS["Geodetic latitude", NORTH], AUTHORITY["EPSG","4289"]], PROJECTION["Oblique_Stereographic", AUTHORITY["EPSG","9809"]], PARAMETER["central_meridian", 5.387638888888891], PARAMETER["latitude_of_origin", 52.15616055555556], PARAMETER["scale_factor", 0.9999079], PARAMETER["false_easting", 155000.0], PARAMETER["false_northing", 463000.0], UNIT["m", 1.0], AXIS["Easting", EAST], AXIS["Northing", NORTH], AUTHORITY["EPSG","28992"]] Bbox = SRSEnvelope[134090.845625 : 134182.746875, 448994.616875 : 449060.530625] CQLFilter = null Elevation = [] FeatureId = null ViewParams = null BgColor = java.awt.Color[r=255,g=255,b=255] FeatureVersion = null StyleVersion = null Tiled = false StyleFormat = sld ValidateSchema = false TilesOrigin = null StyleBody = null SldVersion = null Version = 1.1.1 Request = GetMap Get = true BaseUrl = http://gng-ap713.nieuwegein.nl:80/geoserver/ RawKvp = {TRANSPARENT=true, BBOX=134090.845625,448994.616875,134182.746875,449060.530625, VERSION=1.1.1, FORMAT=image/png, SERVICE=WMS, HEIGHT=1255, LAYERS=nieuwegein:KAAS, REQUEST=GetMap, STYLES=, SRS=EPSG:28992, WIDTH=1750} RequestCharset = UTF-8 2014-10-23 17:18:21,818 DEBUG [wms.map] - Writing png image ... 2014-10-23 17:18:21,818 DEBUG [geotools.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 2014-10-23 17:18:21,819 DEBUG [geotools.styling] - number of fts set 1 2014-10-23 17:18:21,877 DEBUG [geoserver.filters] - Not compressing output for mimetype: image/png 2014-10-23 17:18:21,879 DEBUG [wms.map] - Writing png image ... done!
------------------------------------------------------------------------------
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
