Hi all,
I'm trying to add basic indexing support for the SQLServer jdbc project.
Currently queries that hit the database always perform full table scans and are
of the form:
SELECT "ID",CAST("geom".STSrid as VARCHAR) + ':' + "geom".STAsText() as "geom"
FROM "Roads"
It obviously needs a WHERE filter added to make use of any server-side indexing
support, something like:
WHERE geom.Filter(geometry::Parse(
'POLYGON ((5 5, 10 5, 10 10, 5 5))')) = 1;
Can anyone point me in the right direction?
It looks like the main class (org.geotools.data.sqlserver.SQLServerDialect)
extends BasicSQLDialect. I'm assuming I
need to override "public FilterToSQL createFilterToSQL()" and return a new
class SQLServerFilterToSQL that extends
FilterToSQL. .. But this method never seems to get called.
Ideas?
Cheers,
Kevin
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
