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> 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 > 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
