List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 20 1999 7:06pm
Subject:Re: eq_ref optimization -- please help (fwd)
View as plain text  
At 03:21, 19990820, Jani Tolonen wrote:
>---------------------------------------------------------------------------
>This is ok, but in your new server you have:
>---------------------------------------------------------------------------
>In table carddata:
>
>artistID  char(5), key (artistID)       /* just like above */
>
>and in table artistdata:
>
>artistID  int(9) unsigned not null auto_increment, primary key (artistID)
>---------------------------------------------------------------------------
>
>MySQL can't optimize the latter, because the data types are different.

Just a quick note:  MySQL 3.23 will use keys, even when the data types
are different.  It's still better to use the same type, but you can
get away with some sloppier database designs and still have decent
performance.

Tim
Thread
eq_ref optimization -- please help (fwd)jeremy brand20 Aug
  • eq_ref optimization -- please help (fwd)Jani Tolonen20 Aug
    • Re: eq_ref optimization -- please help (fwd)jeremy brand20 Aug
    • Re: eq_ref optimization -- please help (fwd)Thimble Smith20 Aug