Category Filtering: 'couchbase'

Couchbase - Big OFFSETs can be a big problem

Category Couchbase, N1QL, NoSQL, SQL

Dealing with large data sets and big data can often call for new techniques to optimize performance.  When you have a few million documents or rows, you can do things differently than when you have to deal with tens of millions of rows or documents in either a standard SQL database or a NoSQL database like Couchbase.  One thing we noticed at CKH is that in very large document stores, the OFFSET and LIMIT style pagination on both N1QL queries and Views in Couchbase was getting slow as the OFFSET grew larger.  This becomes a problem when you want to build efficient, consistent paging into your system.  Not to worry, Couchbase provides a solution.


Using insertDesignDocument to Add Views

Category Couchbase, insertDesignDocument

If you have multiple views to set up, this is something that should not be overlooked. It is well worth the time setting up a service to import all of your views automatically. It will save both yourself and others the pain of manually adding views in Couchbase. 


Application Persistent Database Connections

Category asynchronous programming, Couchbase, JavaScript, Tips

Applications under stress stress out their databases.

This post explores solutions to aid applications to persistently connect to their database when under unusual stress.

Couchbase is demonstrated specifically.


Using getMulti in Couchbase

Category Couchbase, getMulti

Do you ever find yourself making Couchbase calls inside of a loop to get your documents, and you ask yourself if there is a better way? One handy method in the Couchbase SDK, version 4.5 or greater, is getMulti, a variant of the get method that allows you to perform bulk retrieval operations. 


1