On Tue, Jan 30, 2001 at 03:20:27PM +0800, Sam Wong wrote:
> Personally speaking, if the index > 256, it will lost the meaning of
> indexing...
Perhaps.
In this particular case it doesn't. I need to ensure that each URL
exists only once. And it is entirely possible to have a URL with 300
characters in it.
I'm looking into alternatives now. The prospect of having to recompile
the master and slaves with a higher value for the max key length
doesn't appeal to me right now. I have "real" work to do...
Perhaps we'll be able to tweak that value on a per-table basis in
versions 4.x...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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