From: Björn H. (J. <ji...@co...> - 2011-05-27 19:53:28
|
No support for base dbms caps for SQL Server 2008 ------------------------------------------------- Key: GEOT-3611 URL: http://jira.codehaus.org/browse/GEOT-3611 Project: GeoTools Issue Type: New Feature Components: data sqlserver Reporter: Björn Harrtell Attachments: GeoTools-r37329-sqlserver-base-dbms-caps.diff I'm not sure this is simply a mistake but is seems like the SQL Server 2008 supporting code does not add base dbms caps which means for instance that it can't build LIKE filters (and probably more?) - currently when using GetFeature with a like filter it will ask the db for all data and filter clientside causing performance problems (since no index can be used and full data is returned) Supplied patch simply enables base dbms caps and initial tests seems to indicate that it works. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |