Query Result Cache
Reduce database workload by serving repeated SELECT queries from the DataSunrise proxy cache.
Product overview
What this product covers
Reduce database workload by serving repeated SELECT queries from the DataSunrise proxy cache.
Query Result Cache reuses results without database schema changes. Choose workloads that can tolerate a defined freshness window.
Control Cache Lifetime and Capacity
Configure caching per database instance through Actions > Result Cache Settings. Set memory and entry limits, lifetime in seconds, maximum result size, and maximum query length.
Make Data Freshness Explicit
Database changes do not automatically invalidate cached results. Entries remain until expiry, eviction, or manual clearing. Use a shorter lifetime where freshness matters.
Monitor Cache Performance
Open Monitoring > Performance > Result Cache Rate to review hits, misses, entries, and evictions, or clear the cache.
Frequently Asked Questions
Which deployment mode is required?
Proxy mode. Sniffer and Agent modes do not support this feature.
Which databases are supported?
PostgreSQL, MySQL, Microsoft SQL Server, Oracle, and compatible variants. Confirm coverage for your deployment.
Where can I learn more?
Read Faster Reads with Query Result Cache or visit the documentation.
Map the right workflow