Search Cache with SQL

NCache provides a faster and efficient searching mechanism which lets you search your cache according to a given criteria and gets the result set. Various ways to search the cache according to SQL queries are explained in the successive chapters.

In This Section

SQL Overview
Discusses the basic overview of searching cache with SQL along with the topology wise behaviour.

SQL Search for Objects
Discusses how to search the cache for objects according to the query criteria.

SQL Search for Keys
Discusses how to search the cache for keys according to the query criteria.

Using IN Operator
Discusses how to use the IN operator in SQL like format.

Using LIKE Operator
Discusses how to use the LIKE operator in SQL like format.

Using GROUP BY
Discusses how to use the GROUP BY clause in SQL like format.

Using ORDER BY
Discusses how to use the ORDER BY clause in SQL like format.

Delete SQL Statements
Discusses how to delete the items from the cache using SQL like format.

Using Date Time Functions
Discusses how to use the Date funtions for querying the data.

Using Logical Query Operators
Discusses how to use the logical operators for querying the data.

SQL Reference
Explains the SQL syntax and all the query formats supported by NCache.