[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-bounces at lists.osgeo.org 
> [mailto:mapguide-users-bounces at 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 at lists.osgeo.org  <mailto:mapguide-users at lists.osgeo.org>
> 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
> mapguide-users at lists.osgeo.org
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/840f3899/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 3987 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/840f3899/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gemtec.png
Type: image/png
Size: 3987 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/840f3899/attachment-0001.png>