TorgoX noted that one of his journals was not showing up in the fulltext journal search by the term "obviously". Hm. After some searching br Krow, it is discovered that MySQL 3.x has a stopword list compiled in if COMPILE_STOPWORDS_IN is defined, and obviously is a stopword. Yow. We can edit the list, undef the COMPILE_STOPWORDS_IN, or not use that word anymore!
Re:Yikes
pudge on 2002-02-24T00:08:26
I think it's quite overdone too, but OTOH, these words don't really tell very much at all about the content of a given bit of text, in the general sense. Were I looking for TorgoX's journal entry in question, the chances of me looking for it by searching for "obviously" are pretty slight. The only journal entry I might think of looking for by that word is this one here.:-D Re:Yikes
vsergu on 2002-02-24T04:39:51
That's true, but if someone is searching for "obviously" then presumably they have a reason for it, and it doesn't seem like you'd save that much room in your indexes by leaving it out.
The specific problem that caused me to delve into the list of stop words in the other search software was that people were unable to search for the cigarette brand More (this was a database of tobacco company documents released as a result of court orders) because "more" was a stop word.
I guess that's a good reason not to name your band The The.Re:Yikes
pudge on 2002-02-24T14:04:46
That is an interesting point I've thought of in the past, but not in terms of stopwords; what kinds of brands/labels/names did people pick previously that they would no longer pick because of no available domain name or weak search results?Re:Yikes
vsergu on 2002-02-24T14:59:25
I've always been annoyed that Microsoft doesn't choose searchable names for their products. It's much easier to search for WordPerfect than for Word (or Access or Excel or Windows or...). I assume searchability is why Allaire changed the name Cold Fusion to ColdFusion.
By the way, the username and the word "Journal" (but not, for some reason, the "'s") in the heading have been white in light mode for a few weeks, which makes them invisible with normal settings. Probably something that got changed around the time you added the immensely useful bookmarkable links for individual comments. I know, people who use the light mode are strange. I got used to it on Slashdot back when I was using a dialup connection and a Pentium 90 with 16 MB of RAM.
Also, is there a list of journal entries ordered by number of comments somewhere? Or would that just cause a snowball effect for the big discussions?Re:Yikes
pudge on 2002-02-24T15:53:40
No plans to list journals by # of comments. The light mode problem should be fixed at next update (comitted to CVS a few days ago, IIRC).Obviously bingo
jmm on 2002-02-25T14:44:17
My father-in-law has been noting how frequently the word obviously is said during interviews. Once he pointed it out, they were, obviously, omnipresent.
