Tag: performance

Develop with Agility, Develop at any Scale with Couchbase on Cisco UCS

Author’s note: This excerpt from the Couchbase on Cisco UCS® solution brief is published on behalf of Cisco. Full solution brief for Couchbase on Cisco UCS® is available later in this blog. As the world migrates to a digital economy, businesses are...

/ February 16, 2018

Database Pagination: Using OFFSET and Keyset in N1QL.

Read the pagination background in my previous article: http://ico9.allcrypto.company/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand.  Using OFFSET and LIMIT is the easy way to write...

/ January 11, 2018

Comparing Couchbase Views with Couchbase N1QL & Indexing.

As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more.  It’s logical to ask the comparative question between them.  Here is a table comparing both.  This is...

/ December 4, 2017

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
Couchbase tooling

Tooling Improvements in Couchbase 5.0 (Update)

Tooling improvements have come to Couchbase Server 5.0. Note: this is an updated repost of Tooling Improvements in Couchbase 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization –...

Monitoring and profiling

Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)

Profiling and monitoring for N1QL are a big part of the Couchbase Server 5.0 release (now available for download). Note: this is an updated repost of Profiling and Monitoring in Couchbase Server 5.0 Preview (Update). Query Workbench Once again, I’ll...

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

N1QL: A Practical Guide. Second Edition

Two years and two weeks ago, on a crisp fall day at Wall Street in New York, we launched N1QL in Couchbase 4.0. Even before the launch, we had customers using pre-release N1QL because it solved the critical business problem:...

/ October 26, 2017

Optimize N1QL performance using request profiling

Monitoring uncovered the resource hog. Now what? Couchbase Server 4.5 introduced a mechanism to keep an eye on executing requests, so that slow performers could be highlighted. This DZone article covers the subject of N1QL monitoring in great detail, but...

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.