Ciao Tim, Jody is right, you bypassing GeoServer internal machinery creating connection pools over and over (not even sure you are dispoing them at the end...).
To rely on GeoServer internal machinery you can follow this example: https://github.com/afabiani/geoserver-enterprise/blob/downloadServices-latest/src/extension/wps-download/src/main/java/org/geoserver/wps/gs/DownloadProcess.java#L141 There we are trying to get ahold of the FeatureTypeInfo in GeoServer for a layer to extract features for a custom download service. Check the sequence of layer name --> layerInfo --> ResourceInfo Then, if the ResourceInfo is a FeatureTypeInfo (vector layer) we go to the right download service: https://github.com/afabiani/geoserver-enterprise/blob/downloadServices-latest/src/extension/wps-download/src/main/java/org/geoserver/wps/gs/VectorDownload.java#L80 Sorry to be this short but I believe you can get some good indications anyway. Regards, Simone Giannecchini == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- On Sun, Mar 2, 2014 at 4:58 AM, Jody Garnett <[email protected]> wrote: > You may wish to limit this discussion to the user list. > > If you use getFeatures( Query ) you can limit the result set produced, which > should be significantly faster then allowing the database to queue up a > larger result set which is then mostly ignored. > > As for your delay, you did not indicate which database you were using - but > in general obtaining a connection can be quite expensive which is why we use > a connection pool internally to recycle connections. It may be luck of the > draw which process is stuck obtaining a new connection, it is best to do > your performance comparison over several requests. > > Jody Garnett > > > On Sat, Mar 1, 2014 at 4:05 AM, Keane, Tim <[email protected]> wrote: >> >> Geoserver 2.5-RC1 >> Geotools 11-RC1 >> >> The GetBblAndBin process (attached) is doing a bbox query for BUILDING >> features (Bin)... >> The query for PLUTO features (Bbl) has been commented so as to have a >> reasonable comparison to a WFS GetFeature request for BUILDING. >> >> The WPS process takes in excess of 5 seconds to complete, while a WFS >> GetFeature is nearly instantaneous >> (http://msdlva-gisapp01.csc.nycnet:82/geoserver/wfs?request=GetFeature&version=1.1.0&typeName=public:BUILDING&BBOX=984450,203736,984453,203739,EPSG:2263&outputFormat=application/json). >> >> The queries performed by the WFS and WPS are nearly identical except for >> the record number limiter of 30000 in the WFS. >> >> I have included 2 debug logs attached (wps.txt, wfs.txt). Of particular >> concern are the following 2 lines from the WPS log where 5 seconds elapse: >> >> 28 Feb 11:37:50 DEBUG [org.geotools.jdbc] - CREATE CONNECTION >> 28 Feb 11:37:55 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION >> >> I am not sure what is going on here, but I guess I am not accessing the >> FeatureSource in an optimal manner. >> >> Thanks in advance for any assistance. >> >> -Tim >> >> >> >> >> ------------------------------------------------------------------------------ >> Flow-based real-time traffic analytics software. Cisco certified tool. >> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer >> Customize your own dashboards, set traffic alerts and generate reports. >> Network behavioral analysis & security monitoring. All-in-one tool. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk >> _______________________________________________ >> Geoserver-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-devel >> > > > ------------------------------------------------------------------------------ > Flow-based real-time traffic analytics software. Cisco certified tool. > Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer > Customize your own dashboards, set traffic alerts and generate reports. > Network behavioral analysis & security monitoring. All-in-one tool. > http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ------------------------------------------------------------------------------ Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
