[mapguide-users] ODBC Points Performance

[Jon Rizzo]

I was told specifically the oposite - that ODBC performance of SQL Server is
slower than all other ODBC providers, including Access.  I have not verified
this claim, but I can tell you that selection is particularly slow with
points coming from SQL Server.  I have also had a performance problem
selecting polygons if they are joined with data coming from SQL Server.  I
don't know enough about the problem to know if this is a MapGuide or a
Microsoft issue but selection on my site is terribly slow because of this.


Jon



None None-9 wrote:
> 
> Is anyone using ODBC to Access to display point layers on a production
> server? Are there known issues with selecting and overall speed? I am
> assuming yes, and if so has anyone used MS SQL for the same thing and
> notices an improvment with the Enterprise FDO?
> 
> The Rock
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/ODBC-Points-Performance-tf4201424s16610.html#a11951968
Sent from the MapGuide Users mailing list archive at Nabble.com.