Tag: performance

Testing N1QL Workloads with Apache JMeter

Testing N1QL Workloads with Apache JMeter

One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...

Less Is More: Why Use a Cost-Based Optimizer?

Less Is More: Why Use a Cost-Based Optimizer?

Less is more.  — Ludwig Mies van der Rohe There is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for...

Keshav Murthy September 7, 2019
Primary Uses for Couchbase Primary Index

Primary Uses for Couchbase Primary Index

A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a...

Keshav Murthy August 22, 2019
N1QL Index Advisor: Improve Query Performance, Productivity

N1QL Index Advisor: Improve Query Performance, Productivity

As application developers, your main focus is to design the most efficient queries  for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...

Binh Le May 9, 2019
Search & Rescue: 7 Reasons N1QL Developers Use Search

Search & Rescue: 7 Reasons N1QL Developers Use Search

People don’t want a four key index.  They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...

Keshav Murthy April 22, 2019
Couchbase in Telecom:  MegaFon, Russia

Couchbase in Telecom: MegaFon, Russia

Egor Kovalchuk is a deployment manager in MegaFon, one of the largest telecommunication companies in Russia.  His career in telecom spans more than a decade.  Egor’s team is in charge of developing, integrating, and monitoring multiple business systems and applications...

Riding the Wave to Big Data NoSQL Leadership at Couchbase

Riding the Wave to Big Data NoSQL Leadership at Couchbase

Today, Forrester Research Inc. has recognized Couchbase as a Leader in its “The Forrester Wave™: Big Data NoSQL, Q1 2019.” [download here] Recognition from Forrester is a great honor, because when they say something, the industry sits up and pays...

Create a production-grade Java microservice architecture with JHipster and Couchbase

Create a production-grade Java microservice architecture with JHipster and Couchbase

Tayeb Chlyah is a Java lead architect with solid experience on performance large-scale applications, microservices, and NoSQL databases. He has developed a couple of open source Java libraries for Couchbase.   Introduction Every successful developer needs to keep up to date...

N1QL: To Query or To Analyze?

N1QL: To Query or To Analyze?

Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...

Keshav Murthy January 24, 2019
On Par with Window Functions.

On Par with Window Functions.

Use golf analogy when explaining to executives. Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency improve...

Keshav Murthy November 22, 2018
YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this paradigm perfectly. But when it comes...

Alex Gyryk October 6, 2018
Using YCSB to Benchmark JSON Databases

Using YCSB to Benchmark JSON Databases

Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”.  Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an open way so they can compare...

Keshav Murthy September 10, 2018