• Facebook
  • Twitter
  • Youtube
  • LinkedIn
  • RSS
  • Docs
  • Comparisons
  • Blogs
  • Try NCache
  • Contact Us
Try NCache
Show / Hide Table of Contents

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.

Contact Us

PHONE

+1 214-619-2601   (US)

+44 20 7993 8327   (UK)

 
EMAIL

sales@alachisoft.com

support@alachisoft.com

NCache
  • Edition Comparison
  • NCache Architecture
  • Benchmarks
Try NCache
Pricing
NCache Playground

Deployments
  • Cloud
  • Docker
  • Kubernetes
  • On-Premises
Technical Use Cases
  • ASP.NET Sessions
  • ASP.NET Core Sessions
  • Pub/Sub Messaging
  • SignalR Backplane
  • Internet of Things (IoT)
  • NoSQL Database
  • Stream Processing
  • Microservices
Resources
  • Blogs
  • Foundations
  • Videos
  • Comparisons
  • Shows
  • Whitepapers
  • Articles
  • Tech Talks
  • Magazine Articles
  • Third-Party Articles
Customer Case Studies
  • Testimonials
  • Customers
Support
  • Docs
  • Schedule a Demo
  • Tips
Company
  • Leadership
  • Partners
  • News
  • Events
  • Careers
Contact Us

  • EnglishChinese (Simplified)FrenchGermanItalianJapaneseKoreanPortugueseSpanish

  • Terms of Use
  •  
  • Privacy Policy
  •  
  • Cookie Policy
© Copyright Alachisoft 2002 - . All rights reserved. NCache is a registered trademark of Diyatech Corp.
  • Facebook
  • Twitter
  • Youtube
  • LinkedIn
  • RSS