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-boun...@lists.osgeo.org] On Behalf Of Gordon Luckett Sent: Wednesday, September 8, 2021 10:41 PM To: MapGuide Users Mail List <mapguide-users@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 周宜和 <j...@mail.gaias.com.tw <mailto:j...@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@lists.osgeo.org <mailto:mapguide-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
