Forum now provides searching by word sequences

This area is for the discussion of what's new, what's on your mind, and general photographic topics. A place to meet, make comments on this site, and get the latest community news.

Moderators: rjlittlefield, ChrisR, Chris S., Pau

rjlittlefield
Site Admin
Posts: 24055
Joined: Tue Aug 01, 2006 8:34 am
Location: Richland, Washington State, USA
Contact:

Forum now provides searching by word sequences

Post by rjlittlefield »

When using the forum's built-in search facility, it is now possible to specify word sequences by enclosing them in quotes.

For example, a search for posts by rjlittlefield, containing diffraction blurring without the quotes, returns 75 replies after this post, but only 52 when quotes are added as in "diffraction blurring" .

A search for "diffraction blurring" AND ("underlying issue" OR "pretty happy") quickly finds those two old posts (and a couple of new posts, including this one).

Words or phrases can be excluded by using the minus sign, as in grating -diffraction .

There are some oddities in the facility. As one example, I had expected that grating AND NOT diffraction would also work to exclude a word. But no, that gives the same result as "grating" AND "diffraction", with NOT excluded as too short, too common. As a second example, specifying the query as "diffraction blurring" AND ("underlying issue" OR "pretty happy") provides a result page that says
Searched query: +"diffraction blurring" +("underlying issue" "pretty happy")
but then actually specifying that form as a new query finds fewer matches!

I plan to stick with the AND/OR/parenthesis notation that I rashly imagine I understand.

This improved search facility is provided by switching the forum configuration from "phpBB Native Fulltext" to "MySQL Fulltext". I do not know exactly what that means, under the covers, but both facilities are provided -- selectable one at a time -- by the standard phpBB distribution.

--Rik

Scarodactyl
Posts: 1715
Joined: Sat Apr 14, 2018 10:26 am

Re: Forum now provides searching by word sequences

Post by Scarodactyl »

My favorite thing is it no longer discards short words or ones that show up frequently, so it's possible to search for things like tube lens test. Thank you very much for the great upgrade!

rjlittlefield
Site Admin
Posts: 24055
Joined: Tue Aug 01, 2006 8:34 am
Location: Richland, Washington State, USA
Contact:

Re: Forum now provides searching by word sequences

Post by rjlittlefield »

Thanks for the kind words. It does seem like a good change, fairly painless so far.

There is still a limit on word length. Only words that are 4 characters or longer can be searched for.

I'm still exploring whether we can reduce that. The limit is set as a server-wide parameter in the MySQL configuration, so it's not a trivial thing that I can just tweak and evaluate using the demotest forum.

(Yes, having that limit be a property of MySQL in general, not specific to the database, sounds like crazy archaic design to me too. I have no idea why MySQL does it that way.)

--Rik

Lou Jost
Posts: 6229
Joined: Fri Sep 04, 2015 7:03 am
Location: Ecuador
Contact:

Re: Forum now provides searching by word sequences

Post by Lou Jost »

Thanks for doing this, Rik. It greatly improves the functionality of this wonderful forum.

Post Reply Previous topicNext topic