MySQL question - perhaps interesting?

[Lennart Sorensen]

On Sat, Mar 12, 2005 at 08:02:49PM -0500, Zbigniew Koziol wrote:
> I should have say: tens of thousands of records (words). I mean most of 
> the words that are used in English most frequentely.
> 
> Both, Lucene and TextSTAT are interesting and new for me (thanks for the 
> info) but these are not related much to my project. I will use Gutenberg 
> project to get words (a bit old words, but thats good enough). Of course 
> I could better scan the web. Thats not a problem either.
> 
> 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?

The idea of a decent database is that it indexes things to try and make
access to all data equaly fast.  If the order you populate the database
matters, then the database is broken by design.

> Users of web page will enter some text into the form. Computer will 
> search for transcription of every word entered. The PHP program I am 
> using (translation by me from Visual Basic) is good for small number of 
> words but at large amounts of text web server times out. So instead of 
> calculating transcription every time, for every word, I wanted rather to 
> create a database of words and their transciptions.

Lennart Sorensen
--
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