[Geotools-devel] [JIRA] (GEOT-5236) Getting features intersecting with a polygon

[Roel De Nijs (JIRA)]

Title: Message Title

Roel De Nijs created an issue   GeoTools / GEOT-5236 Getting features intersecting with a polygon Issue Type: Improvement Assignee: Unassigned Components: jdbc-sqlserver plugin Created: 02/Oct/15 3:30 PM Environment: SQL Server 2008 R2 Priority: Medium Reporter: Roel De Nijs I did a very simple test using one of our queries with different combinations of Filter and/or STIntersects in the WHERE-clause: a) only Filter: 80836 records in 4215ms b) only STIntersects: 77729 records in 5017ms c) Filter and STIntersects: 77729 records in 11364ms I executed every query using the SQL Server Management Studio and before each query I removed the query plans. Then I executed every query again using Microsoft JDBC Driver for SQL Server (version 4.0.2206.100) and the time needed to execute the query is pretty similar. Before executing each query, I removed the query plans as well. a) only Filter: 80836 records in 4459ms b) only STIntersects: 77729 records in 5180ms c) Filter and STIntersects: 77729 records in 11604ms All these tests are executed against SQL Server 2008 R2. Add Comment   This message was sent by Atlassian JIRA (v7.0.0-OD-07-011#70107-sha1:db940e9)

------------------------------------------------------------------------------

_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel