Results for: fts

FTS Flex Index vs GSI Indexes in Couchbase Server 6.6

FTS Flex Index vs GSI Indexes in Couchbase Server 6.6

In this article, we will touch on some practical examples starting with N1QL queries using GSI Indexes and simulate a dataset that over time grows not just with document size, but the actual document structure growing as well. Couchbase Server makes flexible...

August 12, 2020
FTS and N1QL: Better Performance Querying Multiple Arrays

FTS and N1QL: Better Performance Querying Multiple Arrays

Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays.  In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...

Introducing FTS with N1QL

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

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...

September 23, 2019
Running FTS Queries in N1QL

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...

FTS Performance Improvements in 6.5.0 – Part 2

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 would...

July 11, 2019
A Glimpse of FTS Performance Improvements in 6.5.0 – Part 1

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 a...

July 3, 2019
N1QL & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL

N1QL & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL

With Couchbase v6.5, Full-Text Search is now integrated into the Couchbase N1QL query construct. Customers can now leverage FTS indexes directly with N1QL. This provides developers a single API to combine N1QL exact predicate matching and FTS powerful searching. The...

December 11, 2018
Building a Shazam-like app to understand how Tokenizers and Filters work | FTS Part 2

Building a Shazam-like app to understand how Tokenizers and Filters work | FTS Part 2

In the previous blog post, we talked about why full-text search is a better solution at scale to implement a well-designed search in your application. In this second part, we are going to deep-dive on the Inverted Index and explore...

Why you should avoid LIKE % | Deep Dive on FTS – Part 1

Why you should avoid LIKE % | Deep Dive on FTS – Part 1

Search was probably one the most overlooked features in past applications. However, in recent years, it has really gotten all the attention it deserves as we have finally realized how it can increase sales or shape user’s behavior and engagement....

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Mobile 2.0, introduces powerful Full Text Search (FTS) capabilities on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL,...

FTS With Facets in Couchbase NoSQL With Node.js

FTS With Facets in Couchbase NoSQL With Node.js

Earlier this month I had written about using facets with Full Text Search (FTS), a subject that is often considered scary. In this previous tutorial we had configured an FTS index and a sample application with the premise of being...