Tag: Index

Database Indexing Best Practices

Prelude: What is Database Indexing? Asynchronous Indexing: Global Secondary Indexes in databases — Couchbase, for example — can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index-specific...

Introducing the Query Interface in Couchbase Mobile 2.0

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, brings a plethora of new features and enhancements. We discussed one such enhancement, namely the new replication protocol between in an earlier blog post on Replication 2.0. In this blog post, we will introduce you...

Create the Right Index, Get the Right Performance.

Create the Right Index, Get the Right Performance.

Introduction There are three things important in database systems: performance, performance, performance. For NoSQL database systems, there are three important things: performance at scale, performance at scale, performance at scale. Understanding the index options, creating the right index, with the...

November 12, 2017
Optimizing Database Pagination using Couchbase N1QL.

Optimizing Database Pagination using Couchbase N1QL.

Background: How does Google do it? When you google something or anything, it gives you back top relevant results, tells you an approximate number of documents for your topic — all under a second.   Here are some high-level pointers: https://www.google.com/search/howsearchworks/algorithms/...

November 2, 2017
Blazing Fast Index Performance with Plasma

Blazing Fast Index Performance with Plasma

In the earlier post, we got an opportunity to introduce Plasma as the new performant storage engine that powers Global Secondary Indexes in Couchbase 5.0(beta out!). We saw some of the features of Plasma and how it is designed with...

How to transition from Equivalent Indexes to Index Replicas?

In the previous post, we saw the benefits of using index replicas over equivalent indexes.  Let’s say you are on Couchbase Server 4.x and have the following 3 equivalent indexes spread across 3 nodes; and with Couchbase 5.0 Beta available,...

Diving into Couchbase Index Replicas

With Couchbase Server 4.x, customers used to create Equivalent Indexes to satisfy the twin requirements of keeping the indexes highly available and to load balance the N1QL queries. What this meant was that the exact same index definition was used...

Using the New Plasma Storage Engine for Couchbase Indexes

After two generations of success using ForestDB, the team responsible for Couchbase indexes has unveiled a new, blazing fast base storage engine: Plasma. In this post, we’ll introduce you to its features and benefits and what you can expect when...

N1QL Performance and Feature Enhancements in Couchbase 5.0

With Couchbase 5.0 nearing stable release, it is a good idea to revisit some of the enhancements, both in performance and features, that are coming with the N1QL technology.

Perform Various N1QL Queries without Indexes in Couchbase Server

As you probably already know, you’re able to query Couchbase NoSQL documents using a SQL dialect called N1QL.  This is made possible through indexes that you create on documents in your Couchbase Buckets.  However, what if I told you that...

N1QL: A Practical Guide

N1QL: A Practical Guide

N1QL is designed to help developers easily develop applications to solve real-world problems.  Technically, N1QL is designed to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. N1QL takes inspiration from SQL...

March 17, 2017

Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build

With the recent March 2017 Developer build of Couchbase there were many bug fixes, but also feature enhancements to core technologies like N1QL.  For example, now indexes can be created on various meta information such as the document cas and...