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

[周宜和]

Hi Jackie

 

sorry about my previous Email 

select top 1 GeomColumnName from GeomTableName where GeomColumnName is not null

if the all geom data is null 

will cause  full table scan, make sqlserver cpu busy again.

Please keep now version SampleColumnSrid  is good sample .

Just select top 1 GeomColumnName from GeomTableName

 

From: 周宜和 [mailto:jyh at mail.gaias.com.tw] 
Sent: Saturday, September 11, 2021 9:39 AM
To: 'MapGuide Users Mail List' <mapguide-users at lists.osgeo.org>
Subject: RE: [mapguide-users] sqlserver view is no limit row search STSrid ?

 

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-bounces at lists.osgeo.org] On Behalf Of Gordon Luckett
Sent: Friday, September 10, 2021 6:22 PM
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org <mailto:mapguide-users at 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 <jumpinjackie at gmail.com <mailto:jumpinjackie at 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 at lists.osgeo.org <mailto: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/20210911/27907bfa/attachment.html>