Category: Full Text Search
Introducing FTS with N1QL
Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...
Few Index Management Tips – FTS Best Practices Part II
We have already seen a handful of best practices for defining an FTS index in part1, now let’s explore a few useful tips about the operational and maintenance aspects of an index. A user who is new to the...
Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...
Customer 360 – Part 4 – Analyzing Your Data
OK, so we’ve looked at building aspects of a Customer 360 solution in previous posts. We looked at an overview of what’s involved in part 1, and since you’re reading this, I’m assuming that the threat of having to think...
Building autoComplete or typeAhead functionality using Full Text Search
What is autoComplete? Autocomplete as the wikipedia says “Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing” It is also known as Suggestions or Type Ahead or...
FTS Performance Improvements in 6.5.0 – Part 2
For all those who are restlessly eager, let me reveal the deep dark secret of all the performance optimisations in FTS in 6.5.0 is, “ Do less And Do it less often ** ” And I am sure you...
A Glimpse of FTS Performance Improvements in 6.5.0 – Part 1
Ever since the nimbler, refined scorch indexing format released in Couchbase 6.0.0, the FTS team has been pretty excited about the future optimisation potential unlocked with the newer indexing scheme. With the 6.5.0 release, we have essentially embarked on...
Scorch Index Type – Why does it matter?
Index types in Full Text Search (FTS) – refers to the collective specification of the inverted index format and it’s storage aspects. Scorch is the advanced and evolving index type. But before delving further into the details of scorch, its...
Approaches to Query Optimization in NoSQL.
A man returned home after walking around the globe for eleven years. Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...
Search and Rescue: 7 Reasons for N1QL (SQL) developers to use Search
People don’t want a four key index. They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...