Re: Length limit of 500 on primary keys?

[Shankar Unni]

Steve Meyers wrote:

 > In a previous message, I failed to mention one of the main reasons you
 > would NOT want to use a 500-character primary key.  MySQL uses a key
 > buffer to keep as much index information in memory as possible.  The
 > longer the key, the less info it can keep in memory, and the more
 > often it will have to swap to disk.  If your key doesn't fit in the
 > key buffer, my tests have shown that there is a HUGE performance loss.

That's a very good point - thanks for bringing it up.  I'll bring it to the 
attention of the table's owner. Thanks for the ammo..

(Fortunately, this table isn't very big..)
--
Shankar.