Trisha Phoon
csphoon at pc.jaring.my
Wed Apr 30 11:01:02 CDT 2003
i check..is the part where i do this lstrecord.rowsource=lstr Love, Trisha Phoon -------Original Message------- From: accessd at databaseadvisors.com Date: Wednesday, April 30, 2003 23:22:02 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access to MySQL Gurus 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 .. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com .