Re: [Geoserver-users] conncection pool question

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Cool. And just to confirm you are running 2.0.0? Or are you running a 
nightly build?

ba...@os... wrote:
> Hi Justin,
> 
> yes please send me the jar off-list and I'll test it. TIA.
> 
> Best regards,
> Bart
> 
>> Hi Bart,
>>
>> I think I know what the issue is. GeoServer keeps an internal cache of
>> feature types around. By default this cache is capped at 100, which in
>> your case will mean that depending on access to your server you could be
>> seeing a lot of cache misses. Which seems to be what is happening.
>>
>> We should either up the size of the cache or make it configurable. If
>> you are interested i can send you a single jar file that has the cache
>> size raised to say 700 or so. To see if that indeed is the problem.
>>
>> -Justin
>>
>> ba...@os... wrote:
>>> Hi list,
>>>
>>> Andrea's comment got me thinking, and now I am using 1 ArcSDE datastore
>>> with 663 featuretypes instead of the 17 datastores. There was also a
>>> read-only Oracle user that has access to all schemas.
>>>
>>> However the requests are extremely slow now (about 2 minutes). I've
>>> tried
>>> to play with the connection pool settings but to no avail.
>>>
>>> What I see in the log is that before each request Geoserver is disposing
>>> a
>>> lot of featuretypes, and I am guessing this is making things slow.
>>> Although the timings don't seem that long for disposal.
>>>
>>> Or can anybody think of another reason why this setup would make things
>>> so
>>> slow? I am running out of ideas here ....
>>>
>>> .... many disposing lines in front ....
>>> 10 Nov 10:02:10 INFO [org.geoserver.catalog] - Disposing feature type
>>> 'KERNGISNAT_WAZE_KRIBVAK'
>>> 10 Nov 10:02:10 INFO [org.geoserver.catalog] - Disposing feature type
>>> 'KERNGISNAT_WAZE_KUNSTWERKNATUUR'
>>> 10 Nov 10:02:10 INFO [org.geoserver.catalog] - Disposing feature type
>>> 'KERNGISNAT_WAZE_LEIDAMLEIKADE'
>>> 10 Nov 10:02:10 DEBUG [org.vfny.geoserver.requests] - Query is
>>> net.opengis.wfs.impl.QueryTypeImpl@1c228c (group: [], propertyName: [],
>>> function: null, filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ], sortBy: [],
>>> featureVersion: null, handle: null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_BEHEIGOND])
>>>  To gt2: Query:
>>>    feature type: KERNGISNAT_WESC_BEHEIGOND
>>>    filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ]
>>>    [properties:  ALL ]
>>> 10 Nov 10:02:43 DEBUG [org.vfny.geoserver.requests] - Query is
>>> net.opengis.wfs.impl.QueryTypeImpl@1203b56 (group: [], propertyName: [],
>>> function: null, filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ], sortBy: [],
>>> featureVersion: null, handle: null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_FOTOTEKENINGDOCUMENT])
>>>  To gt2: Query:
>>>    feature type: KERNGISNAT_WESC_FOTOTEKENINGDOCUMENT
>>>    filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ]
>>>    [properties:  ALL ]
>>> 10 Nov 10:02:43 DEBUG [org.vfny.geoserver.requests] - Query is
>>> net.opengis.wfs.impl.QueryTypeImpl@117cb47 (group: [], propertyName: [],
>>> function: null, filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ], sortBy: [],
>>> featureVersion: null, handle: null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_FUNCTIEEIS])
>>>  To gt2: Query:
>>>    feature type: KERNGISNAT_WESC_FUNCTIEEIS
>>>    filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ]
>>>    [properties:  ALL ]
>>> 10 Nov 10:02:51 DEBUG [org.vfny.geoserver.requests] - Query is
>>> net.opengis.wfs.impl.QueryTypeImpl@122cae2 (group: [], propertyName: [],
>>> function: null, filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ], sortBy: [],
>>> featureVersion: null, handle: null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_SCHUTSLUISKOLK])
>>>  To gt2: Query:
>>>    feature type: KERNGISNAT_WESC_SCHUTSLUISKOLK
>>>    filter: [ CODEBPN = NMZ1.KS.R.57,004.gr ]
>>>    [properties:  ALL ]
>>> 10 Nov 10:02:51 INFO [org.geoserver.wfs] -
>>> Request: getFeature
>>>         handle = null
>>>         service = WFS
>>>         version = 1.0.0
>>>         baseUrl = http://145.50.148.45:8080/geoserver/
>>>         providedVersion = null
>>>         query = [net.opengis.wfs.impl.QueryTypeImpl@1c228c (group: null,
>>> propertyName: null, function: null, filter: [ CODEBPN =
>>> NMZ1.KS.R.57,004.gr ], sortBy: null, featureVersion: null, handle:
>>> null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_BEHEIGOND]),
>>> net.opengis.wfs.impl.QueryTypeImpl@1203b56 (group: null,
>>> propertyName: null, function: null, filter: [ CODEBPN =
>>> NMZ1.KS.R.57,004.gr ], sortBy: null, featureVersion: null, handle:
>>> null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_FOTOTEKENINGDOCUMENT]),
>>> net.opengis.wfs.impl.QueryTypeImpl@117cb47 (group: null,
>>> propertyName: null, function: null, filter: [ CODEBPN =
>>> NMZ1.KS.R.57,004.gr ], sortBy: null, featureVersion: null, handle:
>>> null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_FUNCTIEEIS]),
>>> net.opengis.wfs.impl.QueryTypeImpl@122cae2 (group: null,
>>> propertyName: null, function: null, filter: [ CODEBPN =
>>> NMZ1.KS.R.57,004.gr ], sortBy: null, featureVersion: null, handle:
>>> null, srsName: null, typeName:
>>> [{http://www.minvenw.nl/rws/agi}KERNGISNAT_WESC_SCHUTSLUISKOLK])]
>>>         maxFeatures = null
>>>         outputFormat = GML2
>>>         resultType = results
>>>         traverseXlinkDepth = null
>>>         traverseXlinkExpiry = null
>>>         formatOptions = {}
>>>
>>> Example request:
>>> <wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS"
>>> version="1.0.0" xsi:schemaLocation
>>> ="http://www.opengis.net/wfs
>>> http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd"
>>> xmlns:xsi="http
>>> ://www.w3.org/2001/XMLSchema-instance"><wfs:Query
>>> typeName="rwsagi:KERNGISNAT_WESC_BEHEIGOND" xmlns:rwsagi
>>> ="http://www.minvenw.nl/rws/agi"><ogc:Filter
>>> xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsEqualTo
>>>> <ogc:PropertyName>CODEBPN</ogc:PropertyName><ogc:Literal>NMZ1.KS.R.57,004.gr</ogc:Literal></ogc:PropertyIsEqualTo
>>>> </ogc:Filter></wfs:Query><wfs:Query
>>> typeName="rwsagi:KERNGISNAT_WESC_FOTOTEKENINGDOCUMENT" xmlns:rwsagi
>>> ="http://www.minvenw.nl/rws/agi"><ogc:Filter
>>> xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsEqualTo
>>>> <ogc:PropertyName>CODEBPN</ogc:PropertyName><ogc:Literal>NMZ1.KS.R.57,004.gr</ogc:Literal></ogc:PropertyIsEqualTo
>>>> </ogc:Filter></wfs:Query><wfs:Query
>>> typeName="rwsagi:KERNGISNAT_WESC_FUNCTIEEIS" xmlns:rwsagi="http
>>> ://www.minvenw.nl/rws/agi"><ogc:Filter
>>> xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsEqualTo
>>>> <ogc:PropertyName>CODEBPN</ogc:PropertyName><ogc:Literal>NMZ1.KS.R.57,004.gr</ogc:Literal></ogc:PropertyIsEqualTo
>>>> </ogc:Filter></wfs:Query><wfs:Query
>>> typeName="rwsagi:KERNGISNAT_WESC_SCHUTSLUISKOLK" xmlns:rwsagi="http
>>> ://www.minvenw.nl/rws/agi"><ogc:Filter
>>> xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsEqualTo
>>>> <ogc:PropertyName>CODEBPN</ogc:PropertyName><ogc:Literal>NMZ1.KS.R.57,004.gr</ogc:Literal></ogc:PropertyIsEqualTo
>>>> </ogc:Filter></wfs:Query></wfs:GetFeature>
>>> TIA.
>>>
>>> Best regards,
>>> Bart
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>> 30-Day
>>> trial. Simplify your report design, integration and deployment - and
>>> focus on
>>> what you do best, core application coding. Discover what's new with
>>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>>> _______________________________________________
>>> Geoserver-users mailing list
>>> Geo...@li...
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
> 
> 

-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.