[fdo-users] King MS SQL Spatial performance problem

Binter Jan Jan.Binter at xanadu.cz
Mon Jun 18 11:33:34 EDT 2007

We tested SL King MS SQL Spatial FDO provider and we found bad
performance with large data. The problem is, there is no spatial filter
used for query data. We found by MS SQL Profiler there are query first
with filter and because there is bad result is query again without the
filter. There is bug in SQL query - I attached log from Profiler to show
it. There is: 
"INNER JOIN dbo.pokus AS a1 ON  sf1.id = a1.id" but "sf1.id" is wrong,
should be "sf1.oid". If it is true, is it possible to fix it?
	Thanks Jan 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql_seq.sql
Type: application/octet-stream
Size: 3302 bytes
Desc: sql_seq.sql
Url : http://lists.osgeo.org/pipermail/fdo-users/attachments/20070618/a171a2ba/sql_seq.obj

More information about the fdo-users mailing list