Steve Meyers wrote: > The problem is that he has it as a primary key, so he wants it to be
> unique as well as indexed. The best solution (and MUCH MUCH MUCH > more efficient) would be to hash each of the four columns, and create > a primary key on that. Integer keys are much faster and memory- > efficient than string keys. Granted, but there's still the problem that the hash may not be unique, thus defeating the purpose of the primary key. I really need a longer primary key. Why is there a limit in the first place, and if there *is* a limit, why is it not configurable at runtime or database creation time? -- 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