[fdo-users] King MS SQL Spatial performance problem
haris at sl-king.com
Thu Jun 28 09:59:52 EDT 2007
I can't see what is causing problems for you.
Is it id-oid column name or something with ST.FilterQuery as you wrote
you changed it.
Can you send what you changed ?
From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Binter Jan
Sent: Wednesday, June 20, 2007 9:47 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] King MS SQL Spatial performance problem
sf1 is alias for function not table - the statement is:
"... FROM ST.FilterQuery(''dbo.pokus'',''GEOM'', at P1 ) AS sf1
INNER JOIN dbo.pokus AS a1 ON sf1.id = a1.id".
If it works on your system you have different version of MS SQL Spatial.
We tried to change ST.FilterQuery function and then it works.
fdo-users mailing list
fdo-users at lists.osgeo.org
More information about the fdo-users