[fdo-users] King MS SQL Spatial performance problem

[Haris Kurtagic]

Hi,

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 ?

Haris

-----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.
	Jan




_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users