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
