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

[周宜和]

thanks for open active ticket

https://trac.osgeo.org/fdo/ticket/996

 

I found mysql is fix by Jan 7, 2020

https://trac.osgeo.org/fdo/ticket/893#comment:5

https://trac.osgeo.org/fdo/attachment/ticket/893/LimitOneSrid.patch

 

 

From: mapguide-users [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Gordon Luckett
Sent: Wednesday, September 8, 2021 10:41 PM
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
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.

 

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 周宜和 <jyh at mail.gaias.com.tw <mailto:jyh at mail.gaias.com.tw> > 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 open url
 

FdoStringP sqlStmt = FdoStringP::Format(

    isview ? L"select [%ls].STSrid as srid from %ls.%ls" : L"select top 1 [%ls].STSrid as srid from %ls.%ls",

    (FdoString*) columnName,

    (FdoString*) this->GetDbName(),

    (FdoString*) fmtObjectName

);

 
https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Owner.cpp#L414
 
and mysql has limit 1 for search STSrid
 

FdoStringP sqlStmt = FdoStringP::Format(

L"select ST_SRID(%ls) as srid from %ls limit 1", (FdoString*)this->GetDbName(), (FdoString*)dbObject->GetDbName());

 

 

https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.cpp#L29

 
 
sorry for my bad engilsh
 

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org <mailto:mapguide-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/mapguide-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210909/80c54fa2/attachment.html>