Hi Jackie I try sqlserverProvider is work find. Thanks for great work.
I still have some question,source code url https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/ColumnGeom.cpp#L100 https://trac.osgeo.org/fdo/browser/trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Owner.cpp#L429 If first row is null data mSRID = owner->SampleColumnSrid( GetParent()->GetName(), GetName() ); mSRID will get -1 then next time into FdoSmPhSqsColumnGeom::GetSRID(),the mSRID is -1 will select top 1 then return -1 to mSRID,again and again. How about select top 1 GeomColumnName from GeomTableName where GeomColumnName is not null From: mapguide-users [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Gordon Luckett Sent: Friday, September 10, 2021 6:22 PM To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org> Subject: Re: [mapguide-users] sqlserver view is no limit row search STSrid ? Hi Jackie, I just wanted to confirm that the build works great and the speed at getting the STSrid in SQL Server is very fast now. On Thu, Sep 9, 2021 at 11:12 AM Jackie Ng <jumpinjac...@gmail.com <mailto:jumpinjac...@gmail.com> > wrote: Please try the following patched SQL Server provider https://download.osgeo.org/mapguide/patches/SQLServerProvider_Ticket996_FDO4.1/SQLServerProvider_Ticket996.zip Extract and overwrite your copy in your MGOS 3.1.2 install - Jackie You wrote: thanks for open active ticket <https://trac.osgeo.org/fdo/ticket/996> https://trac.osgeo.org/fdo/ticket/996 I found mysql is fix by Jan 7, 2020 <https://trac.osgeo.org/fdo/ticket/893#comment:5> https://trac.osgeo.org/fdo/ticket/893#comment:5 <https://trac.osgeo.org/fdo/attachment/ticket/893/LimitOneSrid.patch> https://trac.osgeo.org/fdo/attachment/ticket/893/LimitOneSrid.patch -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org <mailto: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