MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Fred Lindberg Date:April 9 1999 2:22pm
Subject:Re: Performance.
View as plain text  
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?

-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)

Performance.Marc De Caluwé9 Apr
Re: Performance.Fred Lindberg9 Apr
  • RE: Performance.Marc De Caluwé13 Apr
    • Re: Performance.Sasha Pachev13 Apr
RE: Performance.Marc De Caluwé18 Apr
  • RE: Performance.Michael Widenius19 Apr