Automated Query Caching
What: Our proxy provides a transparent look-aside, SQL results, cache solution. We automatically cache SQL results offloading your database. SQL caching is complementary to application, object-level caching.
How: You choose the cache, and we provide the cache logic and invalidation logic.
1) Save database costs by offloading SQL traffic
2) Improve response times up to 20x
3) Save months of development and management per year. There is no complex coding or configuration required.
- Grid-caches supported:
- Redis (Open-source or Enterprise)
- Amazon Elasticache
- Oracle Coherence
- Pivotal GemFire / Geode
- GridGain / Apache Ignite
Question & Answer:
Q1: What about caching stored procedures?
A1: We can cache those too! Heimdall detects when unknown stored procedures were accessed. The proxy will pull the text of the stored procedure, parse out if it uses return values or not, and cache this information.
Q2: Can you cache within a transaction?
A2: Yes. Our analytics give you visibility on whether it is safe to cache within a transaction.
Download a free trial.