[fdo-users] King MS SQL Spatial performance problem
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?
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3302 bytes
Url : http://lists.osgeo.org/pipermail/fdo-users/attachments/20070618/a171a2ba/sql_seq.obj
More information about the fdo-users