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
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users
