MySQL question - perhaps interesting?

[Jim Rootham]

At 8:02 PM -0500 3/12/05, Zbigniew Koziol wrote:
>
>My question is in which order should I populate MySQL database to get
>the fastest search for words: starting from the most frequentely used
>words or from least frequent words? This actually can be tested easiely
>and I will report the result. But perhaps exists a different approach to
>the problem?
>

Shouldn't matter.  Database indices are usually B-trees, so finding anything
should be close enough to constant time not to matter.  Might be mildly
interesting
to know if this true for  MySQL.

Jim Rootham
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml