On Fri, 9 Apr 1999 15:59:27 +0200, Marc De Caluwé wrote:
>mySQL gives me the result (84.245 records) after... 2 hours and 59 minutes.
>The same query (on a similar pc) in Access takes about 6-7 minutes.
>What am I doing wrong???
Can you post table structure from MySQL (describe ...)? Are you doing
this from Access via OBDC, or from the mysql> client? Are the LINK_ID
fields of EXACTLY the same type? Is the Key_buffer big enough to hold
both indices? Other buffers?
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)