Transparent In-Memory Query Caching

Cache frequently repeated queries and identify queries for caching.

Caching benefits many SQL applications with different types of navigational queries. ScaleArc lets you cache responses for frequent, repeating queries – such as searching for a well-known product on an eCommerce site or looking for a popular article on a content site – as well as for more complex queries, such as listings of product pages.

ScaleArc’s patented SQL query cache is the world’s first transparent NoSQL technology, which provides any database-driven application NoSQL-like performance without any application changes. ScaleArc’s SQL query cache is fully ACID compliant and controllable by users as they see fit. By default, no caching is enabled, ensuring the application performs identical to how it would if it were working directly with the database server.

ScaleArc’s cache provides users the ability to cache read-only SQL query responses in an extremely granular manner and to control how and when the cache expires using various methods.

The ScaleArc UI makes it easy to identify query patterns to cache and a simple mouse click adds that pattern to the cache.