| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Apollo (Carmel Entertainment) | Date: | August 20 2003 9:58pm |
| Subject: | Re: Need help optimizing query, awfully slow on only 20000 records | ||
| View as plain text | |||
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query type that allows bypass of Access interpretation. > Two Questions: > > Is the same query running directly on the linux server thru mysql is also > very slow ? > > Have you done a explain plan on the query ? > > Marc. > > ------------------------------------------------- Visit CARMEL MUSIC & ENTERTAINMENT website http://carmelme.com