I have tried to adjust ODBC settings, definitely not a tracing issue. Access is my only choice at this moment but I am open to SQL Server as we use it for some other things. I have not filed any bug reports. I have only managed to cobble together a very basic test. I'm not personally confident that my test is definitive enough to say for sure that this is a bug.
Interesting that Microsoft is planning on phasing out OLE DB in favour of ODBC for SQL Server. http://tdwi.org/Articles/2012/03/27/SQL-Server-2012-End-of-Era.aspx?Page=1 Thanks for the feedback. Gordon McKenzie GIS Coordinator [cid:[email protected]] T: 403.269.8887 / 1.800.478.6162 E: [email protected] canam.com<http://www.canam.com/> 900, 340 - 12th Avenue SW Calgary, AB T2R 1L5 From: [email protected] [mailto:[email protected]] On Behalf Of Andrew DeMerchant Sent: Tuesday, October 22, 2013 6:21 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Mapguide 64 bit and ODBC 64 I don't know that that's a solution - it's definitely a workaround though. I'm not sure if you can set OBDC settings/options from MGOS, but if you can, you might try this (in a nutshell, disabling "when to trace"): http://answers.microsoft.com/en-us/office/forum/office_2010-access/my-solution-to-access-being-slow-with-odbc/a5a6522f-a70f-421e-af1b-48327075e010 I guess the question would be, is this an MGOS problem, or is it an ODBC (MS) problem? If changing the setting above makes the difference, then we've got our answer. On 13/10/22 9:05 AM, Martin Morrison wrote: Perhaps the solution may be to use SQL Server, Oracle or MySQL. Access hasn't been a super big upgrade on Microsoft's plate. Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Andrew DeMerchant Sent: Tuesday, October 22, 2013 7:51 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Mapguide 64 bit and ODBC 64 I'd been trying to decided if this was the version that I should finally make the x64 switch, but it sounds like it's not, I guess. Here's hoping that someone has the time to delve into this and see if it can be fixed for the next release! Have you filed a bug for this officially? On 13/10/21 5:30 PM, gom wrote: It has taken some time to get here but I can say that I was able to install and configure a 32 bit version of Mapguide 2.51 and the performance of the 3 affected data sources is double or better. That is to say, using 32 bit Mapguide and 32 bit Access ODBC driver works more than twice as fast as 64 bit. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-64-bit-and-ODBC-64-tp5082718p5084884.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapguide-users -- ________________________________ [GEMTEC Limited]<http://www.gemtec.ca/> Andrew DeMerchant tel: 506.453.1025 / toll-free: 1.877.243.6832 fax: 506.453.9470 _______________________________________________ mapguide-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapguide-users -- ________________________________ [GEMTEC Limited]<http://www.gemtec.ca/> Andrew DeMerchant tel: 506.453.1025 / toll-free: 1.877.243.6832 fax: 506.453.9470
<<inline: image003.png>>
<<inline: image004.jpg>>
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
