Re: [Geoserver-users] conncection pool question

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

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.