|
|
|
Siim Aus created |
|
Issue Type: |
|
|
Affects Versions: |
2.2-RC3 |
|
Assignee: |
|
|
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: |
|
|
Labels: |
plugin breaking |
|
Priority: |
|
|
Reporter: |
Major