Never a cross word

[thecesspit]

Trivial things that give me an enormous sense of accomplishment #2I managed to finish Tuesday's Independent Cryptic crossword. First time ever, with no cheating or help. I am much chuffed with myself, even if I had to guess that Lungi was a type of Asian Habit, and Nuits St. Georges is a fine wine. Plus it did need a 90 minute journey on the

Comments

[rgl]

Relevancy searches on small tables produce bizarre results. Here's a quote from the MySQL docs: Every correct word in the collection and in the query is weighted according to its significance in the collection or query. ... Such a technique works best with large collections (in fact, it was carefully tuned this way). For very small tables, word distribution does not adequately reflect their semantic value, and this model may sometimes produce bizarre results. For example, although the word MySQL is present in every row of the articles table [in an example given previously], a search for the word produces no results ... The search result is empty because the word MySQL is present in at least 50% of the rows. As such, it is effectively treated as a stopword. For large datasets, this is the most desirable behavior--a natural language query should not return every second row from a 1GB table. For small datasets, it may be less desirable.
When all of your results produce are equally (ir)relevant then it'll just return them all in a

[rgl]

Sorry, I should've said that that quote is from the bit of the MySQL docs that talks about full-text searches.