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
