SQL Query in Cache

NCache provides a SQL-like querying mechanism that allows applications to retrieve indexed cache data based on specified criteria. Because queries are processed on cache servers, applications do not need to retrieve complete datasets for client-side filtering. This can reduce network traffic and the amount of data transferred to clients.

NCache supports SQL-like SELECT statements for retrieving data and DELETE statements for removing items that match specified criteria. Searchable fields and properties must be indexed before they can be used in a query.

In This Section

SQL Query Overview
Explains the NCache SQL-like query model, supported query operations, and query execution across cache nodes and topologies.

Query with ExecuteReader and ExecuteScalar
Discusses how to query the cache using SQL ExecuteReader, ExecuteScalar, and other SQL operations supported by NCache.

Delete Data with ExecuteNonQuery
Explains how to remove cache items that match specified criteria by executing a SQL-like DELETE statement through ExecuteNonQuery.

SQL Reference
The comprehensive SQL syntax guide for NCache, including supported keywords (WHERE, GROUP BY, ORDER BY), aggregate functions (SUM, AVG), and query formats for distributed datasets.