Category: Performance

How to Query JSON Data Using SQL++ for Node.js and Couchbase

How to Query JSON Data Using SQL++ for Node.js and Couchbase

Today’s the day your Node.js app learns “go fetch.” By following this basic tutorial, you’ll learn how to build a REST API for your Node.js app that sends SQL++ (aka N1QL) queries to retrieve data from Couchbase. This post continues...

Tyler Mitchell September 15, 2021
Level Up Your Database Platform Best Practices at Couchbase Connect

Level Up Your Database Platform Best Practices at Couchbase Connect

My colleagues have already told you a lot about how amazing Couchbase ConnectONLINE will be. This free two-day tech conference is the premier event for exploring modern data, NoSQL technology and the cloud. John spoke about the need for modernization,...

Rick Jacobs September 14, 2021
Enable AI-driven Insights Using Couchbase: A Practical Framework

Enable AI-driven Insights Using Couchbase: A Practical Framework

Chris Galy, Chief People Officer at Couchbase, explained in an article you can find with a quick Google search that our mission is about channeling our passion to solve hard problems so our customers can innovate and change the world....

Health Checking a Couchbase Cluster

Health Checking a Couchbase Cluster

Most databases are configured and sized correctly based on the information available at the time of their initial launch, but they tend to become unhealthy or undersized due to organic growth of their datasets and/or changes in their workload profiles....

Remote Links: Analyze Trends with Couchbase Analytics

Remote Links: Analyze Trends with Couchbase Analytics

Introduction to remote links Couchbase is excited to announce its new Remote Links Analytics Service feature in the latest Couchbase Server 6.6 release. Remote links enable real-time operational analytics to obtain and analyze data from multiple Couchbase data clusters and...

Till Westmann August 12, 2020
External Datasets: Accessing AWS S3 in Couchbase Analytics

External Datasets: Accessing AWS S3 in Couchbase Analytics

Introduction to external datasets Couchbase is very excited to announce its new “External Datasets” Analytics Services feature in the latest Couchbase Server 6.6 release. External datasets empower customers to access externally stored data in real-time from Amazon Web Services (AWS)...

Idris Motiwala August 12, 2020
Eventing Improvements: Timers, Handlers and Statistics

Eventing Improvements: Timers, Handlers and Statistics

With the release of Couchbase 6.6 the Eventing Service has major improvements in functionality. We’ve introduced new Eventing Timers that can be cancelled using the cancelTimer() function, or by creating a new timer with the same reference identifier as an...

Using Multiple Disks to Speed Up Couchbase Analytics Queries

Using Multiple Disks to Speed Up Couchbase Analytics Queries

Typical ad-hoc analytical queries have to process much more data than can fit in memory. Consequently, those queries tend to be I/O bound. When the Analytics service was introduced in Couchbase 6.0, it allowed users to specify multiple “Analytics Disk...

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