[fdo-users] FDO Environment setup for Shape images

NallaLokeshKumar loknathms at gmail.com
Thu Aug 2 02:20:05 EDT 2007

Binter Jan wrote:
> 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 
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users

View this message in context: http://www.nabble.com/King-MS-SQL-Spatial-performance-problem-tf3941049s18162.html#a11959051
Sent from the fdo-users mailing list archive at Nabble.com.

More information about the fdo-users mailing list