Results for: fts

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

FTS and N1QL: Better MongoDB in Operator 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
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...

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

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

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

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