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
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.
···
On Sun, Jul 21, 2013 at 4:27 PM, Kristopher Kane <kkane.list@anonymised.com> 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
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users