GeomColumnName from GeomTableName
From: 周宜和 [mailto:j...@mail.gaias.com.tw]
Sent: Saturday, September 11, 2021 9:39 AM
To: 'MapGuide Users Mail List'
Subject: RE: [mapguide-users] sqlserver view is no limit row search STSrid ?
Hi Jackie
I try sqlserverProvider is work find.
pguide-users] sqlserver view is no limit row search STSrid ?
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 mailto:jumpinjac...@gmail.com> > wrote:
Pl
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
Please try the following patched SQL Server provider
https://download.osgeo.org/mapguide/patches/SQLServerProvider_Ticket996_FDO4.1/SQLServerProvider_Ticket996.zip
Extract and overwrite your copy in your MGOS 3.1.2 install
- Jackie
You wrote:
thanks for open active ticket
https://trac.osgeo.o
...@lists.osgeo.org] On Behalf
Of Gordon Luckett
Sent: Wednesday, September 8, 2021 10:41 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] sqlserver view is no limit row search STSrid ?
All Products that use FDO for SQL Server have this problem. It was never fixed
in the FDO library
All Products that use FDO for SQL Server have this problem. It was never
fixed in the FDO library.
MapGuide, Infraworks, AutoCAD Map etc all use the FDO provider and this
runs a full select on every table and view just to get the STSrid for each
one.
On Wed, Sep 8, 2021 at 8:49 AM 周宜和 wrote:
Hi,
I got cpu busy with sqlserver,
My Web Server is mapguide 3.1.2,
Target layer is 15 thousand address point of view,
Then i find source code when table select top 1,but view is no limit row
search STSrid.
when layer preview from view , effect sqlserver cpu high loading.
Source code below,or o
