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

[Gordon Luckett]

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 周宜和 <jyh at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210908/c6c007ac/attachment.html>