Re: [mapguide-users] sqlserver view is no limit row search STSrid ?

2021-09-10 Thread 周宜和
Hi Jackie sorry about my previous Email select top 1 GeomColumnName from GeomTableName where GeomColumnName is not null if the all geom data is null will cause full table scan, make sqlserver cpu busy again. Please keep now version SampleColumnSrid is good sample . Just select top 1 Ge

Re: [mapguide-users] sqlserver view is no limit row search STSrid ?

2021-09-10 Thread 周宜和
Hi Jackie I try sqlserverProvider is work find. Thanks for great work. I still have some question,source code url https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/ColumnGeom.cpp#L100 https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericR

Re: [mapguide-users] sqlserver view is no limit row search STSrid ?

2021-09-10 Thread Gordon Luckett
Hi Jackie, I just wanted to confirm that the build works great and the speed at getting the STSrid in SQL Server is very fast now. On Thu, Sep 9, 2021 at 11:12 AM Jackie Ng wrote: > Please try the following patched SQL Server provider > > > https://download.osgeo.org/mapguide/patches/SQLServer