Re: [Geoserver-users] conncection pool question

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

Justin,

btw, is this cache per datastore?

When I was using 17 datastores and in total the same amount of
featuretypes I was not running into the performance issue.

Best regards,
Bart

> Hi Justin,
>
> I am using 2.0.0.
>
> Best regards,
> Bart
>
>> 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.
>>
>
>
>