[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