[fdo-users] King MS SQL Spatial performance problem

Haris Kurtagic 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 ?


-----Original Message-----
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 mailing list