Category: Performance
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...
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,...
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
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
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...
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)...
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
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
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. — 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...
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...
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...