Default search, Solr, importance of full-text search?

[julian]

@rfc2822 The fact that Solr itself is subjectively (maybe objectively) better at search is actually the primary motivator for me creating the plugin in the first place.

However, the big downside is that Solr is a beast... it requires more resources than NodeBB itself does, and runs on Java+Tomcat, which I have next to no experience debugging

Are you sure you are sorting results by relevancy, and not by, say... post time?

[rfc2822]

@julian said in Default search, Solr, importance of full-text search?:

@rfc2822 The fact that Solr itself is subjectively (maybe objectively) better at search is actually the primary motivator for me creating the plugin in the first place.

However, the big downside is that Solr is a beast... it requires more resources than NodeBB itself does, and runs on Java+Tomcat, which I have next to no experience debugging

This is the main reason why I have really tried dbsearch for a long time before I have decided to give Solr a try. I didn't want it, had to setup an extra VM, learn the config file syntax etc… but at the end, I had search results which were good and I could recommend users to use the search function. Then I noticed that new postings were not indexed, and then I began to wonder how other people manage search, because it couldn't be such a rare requirement to have working full-text search?

Are you sure you are sorting results by relevancy, and not by, say... post time?

I have just clicked on the default search icon on top of the page and entered the queries, as most people do. I have linked the queries in my previous posting for reference, just have a look. The (default) URL parameters seem to be "in=titlesposts&sortBy=relevance&sortDirection=desc&showAs=posts", so yes, these results should be sorted by descending relevance.

[baris]

Yeah I think part of the problem is if you search for http 403 it shows matches for http or 403, searching for "http 403" only returns one result

Also searching in Titles and posts results in topic matches to be at the top so searching for just posts or just titles might lead to better results.

[BartVB]

But a normal user would expect a post with both http and 403 to rank much higher than a post with only one of those terms. Actually I would only expect results with both terms.

It would also be nice if age was taken into account when calculating relevancy. I'm currently only searching with sort set to 'last reply time'. The state of the world in 2014 isn't that relevant to me if there are newer search results.

[julian]

Hah well that's a whole other conversation as to how you prefer to define "relevancy"

In some contexts, time and date is significent... in other contexts, maybe not.

That said, if Solr was working fine for you, and it wasn't indexing, then there was something wrong with the configuration... it should automatically index new posts, just like dbsearch does.

[rfc2822]

@julian said in Default search, Solr, importance of full-text search?:

That said, if Solr was working fine for you, and it wasn't indexing, then there was something wrong with the configuration... it should automatically index new posts, just like dbsearch does.

Well it didn't, although it said the opposite (I even tried to turn off the setting to be sure)

So… is there any chance that full-text search will be re-thinked again in NodeBB and my suggestions will be taken into consideration? Shall I open this topic elsewhere (issues, mailing list, …)

[rfc2822]

@bartvb I have just tried Elasticsearch. The default Elasticsearch plugin included by NodeBB doesn't even allow to (re-)index all posts … which means manual importing. No …

The question is: shall I try to improve the Elasticsearch plugin, creating the 10-th unmaintained fork which is then working on a single instance (mine) until the next major NodeBB update, while overall search is still horrible for 99% of NodeBB users? That's what I wanted to avoid. But it seems like interest in working full-text search is quite low

[BartVB]

@rfc2822 My guess is that the NodeBB project gains the most when nodebb-plugin-dbsearch is improved. I did a quick check of the MongoDB docs and it seems like there is quite a bit of room for improvement when it comes to the implementation of MongoDB fulltext search in NodeBB.

Performance is not really the issue here, I'm guessing that normal MongoDB operations will come crashing down before MonogDB gives up on fulltext-search on really big boards. Which leaves search quality.

As far as I can tell things would already be quite a bit better if by default all searches use an AND operator between al terms and if a term like 'site.com' won't be broken up into 'site' and 'com'. And while you're at it it would be nice if relevance would take age into account

[rfc2822]

For reference: https://github.com/julianlam/nodebb-plugin-solr/issues/34

rfc2822 created this issue in julianlam/nodebb-plugin-solr

closed New postings are not indexed #34

[rfc2822]

@bartvb said in Default search, Solr, importance of full-text search?:

@rfc2822 My guess is that the NodeBB project gains the most when nodebb-plugin-dbsearch is improved. I did a quick check of the MongoDB docs and it seems like there is quite a bit of room for improvement when it comes to the implementation of MongoDB fulltext search in NodeBB.

My experience with database full-text indices is bad. MySQL has a full-text index, too, and I have used it for several projects. It's OK, but the results are not as good as from specialized search engines as Solr. It confirms my prejudices when looking at what the default NodeBB Mongo-based full-text search produces. I also remember what happens when other projects (CMS like Typo3) try to build their own full-text search. It's just horrible and at the end, you still have to use a public search engine with site:.... to find what you're looking for.

Good full-text searching is an extremely complicated task. Why not leave it to specialized projects? I just don't understand why every project needs its own unusable low-quality full-text search instead of

• making use of public search engines (in the end, this is what most people do – redirect to Google), and
• making use of already available, specialized open-source search engines like Solr and Elastic Search if this is not an option?

Of course, the MongoDB full-text index could still be available, but not as only officially supported and advertised solution.

In my opinion, a side project of a database ("oh yes, full-text index would be cool, let's add it quickly") can never provide acceptable results because the topic is too complex. I also guess that the people who have developed Solr are not idiots who like to waste their time for nothing. (Ok, this applies to MongoDB people, too, but maybe the MongoDB full-text index is for use cases where high-quality full-text search is not as important as for a forum.)

[julian]

The implementation here, is for a "good enough" solution for small boards where dbsearch is more than adequate.

While I admire your quest for a "good" search engine for NodeBB, one simply won't exist natively here, a third-party solution must be utilised. We will try our best to tweak the dbsearch results (e.g. implicit AND being one change we ought to adopt), but I personally am hoping for someone to develop an amazing search engine for Node.js so I can use the library as a module

However that may well be unfeasible for a variety of reasons, Node.js not being the right tool being just one of those

[Bri]

@rfc2822 said in Default search, Solr, importance of full-text search?:

Good full-text searching is an extremely complicated task.

This is so true. I do believe you can approach Google-quality search results with a specialized search engine (because within a forum, you have a lot more context on what is important to your users), but it takes some science, metadata, and lots of tweaks to get good results. Good full text search isn't really just full text, it's a combination of a ton of other data, which is why Google is so good at it. The whitepaper on Google search is a taste of the complexity that goes into how they produce such good results.

[rfc2822]

@bri Searching a manageable number of postings (which should contain real text content, mostly without markup and all about a certain topic) should still be easier than indexing the whole Internet (and rank an endless number of pages which are highly "optimized" with SEO to be shown first etc.) Also, things like PageRank are not really applicable to a forum because a posting doesn't have to be linked often to be valuable.

Just had an idea: with Solr, even attachments (of postings) could be indexed

[Bri]

@rfc2822 said in Default search, Solr, importance of full-text search?:

a posting doesn't have to be linked often to be valuable

Well, yes, I was using that as an example. I didn't mean you need to literally use page rank in a forum search engine, that doesn't make sense.

[scottalanmiller]

Wish that I still had info on what it did. it has been quite a while.

[artesea]

@rfc2822 said in Default search, Solr, importance of full-text search?:

What to do? Can you suggest what I can do to get good full-text search working on a private forum? Shall I use the Solr plugin? Which one? Is there an officially supported plugin that's actually being maintained? I'd have to dig into the problem that new postings are not indexed automatically first.

Something I'd like to know the answer to. Was considering AWS and Elasticsearch, but plugin dev around here is lacking any real effort. Forks all over the place and very little comments other than not working on 1.5, 1.6, 1.7, 1.72 etc

Members constantly complain that people a) don't search for topics which already cover their questions and b) complain that when they do search the results are near useless.

Now I understand how challenging search is, especially when the person searching can't even remember the key words to look for, but without changing the options in db-search I can often fail to find my own content when searching for a single word within the title (main trick is to limit the section of the forum, results to title only and order date descending, but I can't ask everyone to learn these).

[rfc2822]

@artesea Currently, the Apache Solr plugin is working here very well. It requires a Solr server, which quite large and runs in a VM here, but it's really worth it.

[Bri]

@artesea said in Default search, Solr, importance of full-text search?:

plugin dev around here is lacking any real effort.

Please stop making comments like this.

1. The code is free and open source so you’re free to fix it.
2. You sound entitled. If you’re paying for the plugin you can complain like this.
3. The lack of effort is really on your part if you’re not willing to contribute.

Free software != free support