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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
