Re: [mapguide-users] Mapguide 64 bit and ODBC 64

[Andrew DeMerchant]

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: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] 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 mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users   -- Andrew DeMerchant tel: 506.453.1025  /  toll-free: 1.877.243.6832 fax: 506.453.9470 _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Andrew DeMerchant tel: 506.453.1025  /  toll-free: 1.877.243.6832 fax: 506.453.9470

_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users