Re: [Geoserver-users] conncection pool question

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

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.
>