Tag: Indexing

5 Steps to Better Database Performance

5 Steps to Better Database Performance

Deploy a Performance Monitoring Solution Use the latest Commercial version of Couchbase Size your infrastructure accordingly Use Prepared Statements Optimize Indexes There are many steps on the road to better database performance. In this post, I will walk you through...

Support for Concurrent Index Creation in Indexing Service

Support for Concurrent Index Creation in Indexing Service

Modern applications are implemented as a set of a large number of microservices. Each such microservice may run independently of many other microservices. Such applications expect underlying databases to support multi-tenancy. Couchbase Server 7.0 has introduced Scopes and Collections to...

December 14, 2021
How to Use Full-Text Search across Couchbase Scopes & Collections

How to Use Full-Text Search across Couchbase Scopes & Collections

The Full-Text Search Service now offers better search performance and resource utilization across your cluster with the introduction of Scopes and Collections in Couchbase 7.0. Let’s take a quick step back: The 7.0 release of Couchbase Server introduces the concept...

August 19, 2021
Here’s How the Index Service Got Upgraded for Couchbase 7.0

Here’s How the Index Service Got Upgraded for Couchbase 7.0

Index builds and updates just got a big performance upgrade with the introduction of Scopes and Collections in Couchbase 7. The Couchbase Server 7.0 release introduces the separation of Bucket data into logical Scopes and Collections on top of the...

August 12, 2021
Data Structures & Queries with Couchbase N1QL (SQL for JSON)

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...

January 27, 2021
Index Advisor Supports Self-Verification and Index Pushdowns

Index Advisor Supports Self-Verification and Index Pushdowns

Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...

January 19, 2021

Couchbase Views and Better Alternatives [Part 1 of 2]

Introduction This blog is meant for users who are familiar with the basics of Couchbase Server and Views. Novice users should start here to gain basic understanding of Couchbase Server and then continue here to get acquainted with Views. Views...

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
Arrays in JSON: Modeling, Querying and Indexing Performance

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

August 4, 2020
Couchbase Server 5.5 Released

Couchbase Server 5.5 Released

Announcing Couchbase Server 5.5 Couchbase Server 5.5 production release is now available! We are very excited to share more information about this substantial extension of the Couchbase Data Platform. This release introduces several new Enterprise Grade features relating to agility,...

July 23, 2018
A Guide to N1QL features in Couchbase 5.5: Special Edition

A Guide to N1QL features in Couchbase 5.5: Special Edition

N1QL was first released with Couchbase 4.0 in the fall of 2015.  After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...

May 10, 2018
Index Partitioning in Couchbase Server 5.5

Index Partitioning in Couchbase Server 5.5

Index partitioning is a new feature available in Couchbase Server 5.5. Check out the Couchbase Server 5.5 Developer Build announcement and download the release for free right now. In this post, I’m going to cover: Why you might want to use index...

March 19, 2018