SQL Query in Cache
NCache provides an efficient, Object-Relational querying mechanism that lets you retrieve cached data based on specified criteria and obtain the result using standard SQL-like syntax. By utilizing SQL queries on the server-side, NCache ends the need to fetch complete datasets for client-side filtering, reducing network latency and optimizing application throughput.
Whether you are making complex searches on indexed objects or performing bulk operations, NCache supports a wide range of SQL operators (SELECT, DELETE, etc.) designed for high-performance caching topologies.
In This Section
SQL Query Overview
A conceptual walkthrough of the SQL architecture in NCache to understand how queries are distributed among the nodes in the cluster and how various caching topologies (Partitioned, Replicated) impact the execution of the queries.
Define Indexes Programmatically
Learn how to optimize query performance by defining search indexes at runtime. This section discusses programmatic configuration of indexes for specific object attributes to ensure faster data retrieval.
Query Data in Cache Using SQL
Discusses how to query the cache using SQL ExecuteReader, ExecuteScalar, and other SQL operations supported by NCache.
Delete Data with ExecuteNonQuery
Discusses how to delete the items from the cache using an ExecuteNonQuerybased on specific criteria.
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.
