[AccessD] Access to MySQL Gurus

Trisha Phoon csphoon at pc.jaring.my
Wed Apr 30 10:10:30 CDT 2003


dear arthur

 when i run the query directly from the database window in Access..the speed
is acceptable.. but when it was running in the program.. using SQL ..it take
way too long.. it seem like hang..but it wasn't..the query return about 2790
records.

 
From,
 
Trisha Phoon
-------Original Message-------
 
From: accessd at databaseadvisors.com
Date: Wednesday, April 30, 2003 22:59:16
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Access to MySQL Gurus
 
MyODBC imposes a performance penalty but it shouldn't be that serious.
What's your performance like if you do the same query directly from the
mysql client? Also, how many rows are being returned?
 
There are about a million tweaks you can apply to MySQL as well.
Arthur 
 
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Trisha Phoon
Sent: April 30, 2003 9:32 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access to MySQL Gurus
 
 
Dear Arthur
 
I am doing similar thing right now... converting the Access database backend
to mysql 
with the front end still in Access XP. The problem i seem to have now is
when my form is running some 
query which then show on the listbox..it take a real long time to show up...
why is that so??what do i need 
to do to the mysql database after i have import them from Access?? Currently
I am using myODBC for 
the linked table. Please advise..
 
 
From,
 
Trisha Phoon
-------Original Message-------
 
From: accessd at databaseadvisors.com
Date: Wednesday, April 30, 2003 16:43:21
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access to MySQL Gurus
 
Hi Arthur
I'll be using Win2000, there are a couple of boxes within this network setup
that are Win95, Win98, Win98SE, I've told the guy he should upgrade the OSes
to Win2000. He's going to upgrade the RAM in all boxes on the network to
384mb. So Win2000 should be OK. Thanks for your help. Cheers Tracy
 
----- Original Message ----- 
From: Arthur Fuller 
To: accessd at databaseadvisors.com 
Sent: Wednesday, April 30, 2003 8:41 AM
Subject: RE: [AccessD] Access to MySQL Gurus
 
 
That will work fine, Tracey. What OS you running? Linux or WindX? Linux can
stretch a tired old box into new athleticism, but with so few users even
WindX will do fine.
 
Any other issues, feel free. I've been down this road 100 times :-)
 
Arthur
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tracy
Sent: April 29, 2003 3:05 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access to MySQL Gurus
 
 
Hi Arthur
Thanks for the info, I was looking at a PIII-466 Celeron with 256mb RAM -
with only 5 users accessing it. So this should be a good starting point.
 
Cheers Tracy
 
 
 
 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 
 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
. 


More information about the AccessD mailing list