February 13, 2019 By Michael Breslin 2 min read

To meet customer demands while improving the scalability and performance of Cloudant, we are introducing a new query style which offers a new way to query a Cloudant database.

The adoption and growth of the IBM Cloudant Lite and Standard plans that we introduced to the IBM Cloud in 2016 have been incredible. However, our customers have a few common requests, with one of the biggest being that the queries request class is too expensive and it’s hard to use a data model that makes use of the cheaper lookups request type.

To meet our customer demands while improving the scalability and performance of Cloudant, we are excited to introduce a new query style which offers a more scalable, faster, and cheaper way to query a Cloudant database.

The info behind partition queries

Partition queries cost up to 20x less and significantly improve response times over global queries. With this new feature, customers can decide at database creation time whether or not to create the database with partitions. Partitioned databases will require a partition key for every document in the database. A partition in a Cloudant database is a logical grouping of documents that can be queried together by specifying the partition key at query time. Common partition keys could include usernames, IoT device ID’s, or locations. Partitioned database documents also have an _id field, but the _id field is in two parts—the partition key and the document key—separated by a “:” character:

Querying a partitioned database with a partition key can be done against MapReduce viewsearch, or Cloudant Query indexes. See the database partitioning documentation for more details on how to leverage this feature and what makes a good partition key in IBM Cloudant.

Renaming request classes

As part of the rollout of partitioned databases, we will be renaming the request classes that make up the provisioned throughput capacity pricing model in IBM Cloudant Lite and Standard plan instances:

  • Lookups will become reads and encompass both document lookups by _id and partition queries.

  • Writes will remain as is.

  • Queries will become global queries to distinguish against the costing for partition queries.

You can continue to scale your Cloudant instances on demand in blocks of:

  • 100 reads/sec

  • 50 writes/sec

  • 5 global queries/sec

See the event types documentation for more details and the specific costing involved when using partition queries.


IBM Cloudant partition queries beta is immediately available for all newly deployed instances in all six major IBM Cloud locations of Dallas, Washington DC, London, Frankfurt, Tokyo, and Sydney. In the coming weeks, we will GA the feature and enable it across all IBM Cloudant environments. If you have any questions, please reach out to support and we will be happy to help you make use of partition queries in your application.

Register now for our webinar on March 19, 2019 to learn how to leverage partition queries.

More from Announcements

IBM and SAP unlock business and industry value with new generative AI solutions 

3 min read - IBM Consulting is delivering on our commitment to co-innovate with SAP and collaborate with our clients. As part of our Value Generation Partnership initiative announced earlier this month with SAP, we are releasing the first 10 of 100 planned AI solutions to help clients transform their industries, optimize their business processes and successfully deliver their SAP programs.  Delivering AI business and industry innovation at scale  With the recently announced Value Generation Partnership initiative, IBM and SAP are co-innovating intelligent industry…

IBM SevOne 7.0: Reaching application-centric multicloud network observability  

2 min read - As enterprises increasingly rely on network connectivity to support cloud-based applications and remote workers, network managers require new methods to monitor and safeguard connectivity across diverse environments, including corporate networks, software-defined WANs and multiple public cloud providers.   According to the recent EMA Network Megatrends Report, responding network professionals believe that 53% of network outages and performance issues could be prevented with improved network management tools, yet only 9% find it very easy to hire skilled networking personnel. This is why…

IBM Hybrid Cloud Mesh and Red Hat Service Interconnect: A new era of app-centric connectivity 

2 min read - To meet customer demands, applications are expected to be performing at their best at all times. Simultaneously, applications need to be flexible and cost effective, and therefore supported by an underlying infrastructure that is equally reliant, performant and secure as the applications themselves.   Easier said than done. According to EMA's 2024 Network Management Megatrends report only 42% of responding IT professionals would rate their network operations as successful.   In this era of hyper-distributed infrastructure where our users, apps, and data…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters