Is the client making a geoserver/psotgress call for each layer or is
geoserver some how scanning the DB once and returning the data for both
layers from the one scan?
* GeoServer does one SQL query per layer, but may perform both at the same
time with separate connections.
When I limit features by style, is geoserver limiting the request before
the DB call or is it just dropping unused features after the call?
* GeoServer encodes as much of the style filter as it can into the native
query (for Postgres/Postgis filters can usually be fully delegated to the
database server.) So choosing your Postgres indices wisely can have a big
impact on rendering performance.
--
David Winslow
OpenGeo - http://opengeo.org/
On Sun, Jul 21, 2013 at 4:27 PM, Kristopher Kane <[email protected]>wrote:
> Hello,
>
> I'm running Geoserver 2.3 and sending OSM (postgres) KML vector to Google
> Earth.
>
> Right now, I'm creating layers with styles that limit features by zoom
> level.
>
> For Example: I've got a layer that shows point data for country names and
> another layer for city names.
>
> I did this so that users could easily click the layers on or off in the GE
> client rather than an 'all or none.'
>
> A couple of questions:
>
> Is the client making a geoserver/psotgress call for each layer or is
> geoserver some how scanning the DB once and returning the data for both
> layers from the one scan?
>
> When I limit features by style, is geoserver limiting the request before
> the DB call or is it just dropping unused features after the call?
>
> Thanks,
>
> Kris
>
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
