Apache Geode

Advanced Querying

This section includes advanced querying topics such as using query indexes, using query bind parameters, querying partitioned regions and query debugging.

• Performance Considerations

  This topic covers considerations for improving query performance.

• Monitoring Low Memory When Querying

  The query monitoring feature prevents out-of-memory exceptions from occurring when you execute queries or create indexes.

• Timeouts for Long-Running Queries

  Configure a timeout value for long running queries, such that they do not complete, and Geode throws an exception when a query runs for longer than the configured value.

• Using Query Bind Parameters

  Using query bind parameters in Geode queries is similar to using prepared statements in SQL where parameters can be set during query execution. This allows you to build a query once and execute it multiple times by passing the query conditions during run time.

• Querying a Specific Member

  A query may return different results depending on the member on which it is executed.

• Querying Partitioned Regions

  Geode allows you to manage and store large amounts of data across distributed nodes using partitioned regions. The basic unit of storage for a partitioned region is a bucket, which resides on a Geode node and contains all the entries that map to a single hashcode. In a typical partitioned region query, the system distributes the query to all buckets across all nodes, then merges the result sets and sends back the query results.

• Query Debugging

  You can debug a specific query at the query level by adding the <trace> keyword before the query string that you want to debug.