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

周宜和 jyh at mail.gaias.com.tw
Wed Sep 8 00:49:34 PDT 2021


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/SQLServe
rSpatial/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/Sc
hemaMgr/Ph/ColumnGeom.cpp#L29

 
 
sorry for my bad engilsh
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210908/e2c3d8ab/attachment.html>


More information about the mapguide-users mailing list