[mapguide-users] Store point geom: ODBC or Native

[Jackie Ng]

There's probably some conversion overhead involved with ODBC points, that you
won't have with native storage. 

Unless you need to have your SQL Server 2008 database interop with other
systems (that can't understand SQL Server 2008 spatial data types), you
should go native where possible.

Also using MSSQL spatial provider exposes the full set of geometry types,
not just points.

- Jackie


zolinko wrote:
> 
> Hi there,
> 
> Can you tell me, how I should store point type geometry in an MSSQL server
> 2008 context?
> Which method is preferred:
> ODBC or MapGuide point type geometry?
> I use Mapguide 2010 Enterprise, so it has "native" support for MSSQL
> Spatial.
> 
> Has anyone some experience in the theme?
> 
> Thanks,
> Zoli...
> 

-- 
View this message in context: http://n2.nabble.com/Store-point-geom%3A-ODBC-or-Native-tp2691070p2691194.html
Sent from the MapGuide Users mailing list archive at Nabble.com.