![]() |
|
|
|
|
Issue Type:
|
![Bug]() Bug
|
|
Affects Versions:
|
2.2-RC3 |
|
Assignee:
|
Andrea Aime
|
|
Attachments:
|
queries.txt |
|
Components:
|
Querylayer, SQLServer |
|
Created:
|
18/Sep/12 12:16 PM
|
|
Description:
|
When performing GetFeatureInfoRequest, query sent to SQL server is not optimized and requires about 600x times more time to complete than in version 2.1-RC2. Queries were performed on same data set with same database rights and structure.
Problem appears to be with sorting resultset with help of subquery (orderded over current_timestamp!!) to get top 50 rows (instead of using just TOP 50 for MSSQL).
This renders this version of SQL server plugin just unusable.
I've included attachment which shows difference of query structures. GetfeatureRequests were not performed on same geographical location but on same data table with approx same zoom level.
|
|
Environment:
|
Sun Microsystems Inc.: 1.6.0_24 (OpenJDK 64-Bit Server VM), Ubuntu 12.04.1 LTS
|
|
Fix Versions:
|
2.1-RC2 |
|
Project:
|
GeoServer
|
|
Labels:
|
plugin
breaking
|
|
Priority:
|
![Major]() Major
|
|
Reporter:
|
Siim Aus
|
|
|
|
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
|
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
