![]() |
|
|
|
|
Issue Type:
|
![New Feature]() New Feature
|
|
Assignee:
|
Andrea Aime
|
|
Components:
|
WMS |
|
Created:
|
03/Jun/13 11:02 AM
|
|
Description:
|
I need an order by in the sql of my WMS request. I am not able to split my style into different FeatureTypes. My data has some kind of z-ordering.
Using Oracle or PostgreSQL I am able to put an order by statement within my view. SQLServer need an additional top and does not perform very well with this construct. So instead of this way I "injected" an order by into your WMS - module and got much better results with queries like 'select geom from geomtable where ... order by sort_col ' instead of e.g. 'select geom from (select top 1000 geom from geomtable order by ...) ...'.
So here are my questions:
1. Is there already a way to set a sortby for WMS - requests?
2. Maybe there is a proposal I missed regarding this?
3. What would be the right way to modify WMS layer configuration to add this kind of feature? Did I miss the developer documentation?
Regards
Tobias
|
|
Project:
|
GeoServer
|
|
Priority:
|
![Major]() Major
|
|
Reporter:
|
Tobias Warneke
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite
It's a free troubleshooting tool designed for production
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap2
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
