Le 24/01/2019 à 14:11, Andrea Aime a écrit :
Wow, it's big... and the feature type names are not a match for the
table names you're using, seems like you're using SQL views?
Yes, SQL view, but basically only selecting all the columns (and doing
simple CASE ... WHEN statement to do things that would be more difficult
in SLD) and filtering on a boolean field.
And while the target table is the same, the sql view definition is not.
What do you mean ?
The SQL view definition is the same, since it's only one single layer.
What is different though is what is added by geoserver, i.e. whats is
after the "AS vtable". But everything inside the subquery (i.e. the view
definition) is the same.
More in general, there are no facilities to figure out
that two feature type styles are based on the same base table and
eventually reorganize the queries accordingly, the renderer
only sees the feature types, has no idea what's behind them, and queries
them one by one.
Well, that is, unless you mean that a specific user visible layer, with
one name, is causing two different queries? But I don't
see that from your query logs.
Yes, that's exactly what I mean. I query a single layer (base on the SQL
view that you can see inside the "vtable" subquery) using the URL that I
previously posted.
Geoserver then issues two different queries, the first time with a part
of the feature type styles, and the second type with the rest of it.
Actually the style is not that big (very subjective, of course), it's a
rendering based on a very simplified version of openstreetmap's
"planet_osm_polygon" table, with a lot less features than on OSM's own
style.
Cheers
--
Arnaud
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
