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.
- Automatic cache invalidation based on incoming writes or updates
- Time-to-Live (TTL) invalidation
- API or query comment/hint-based invalidation
The ScaleArc UI makes it easy to identify query patterns to cache and a simple mouse click adds that pattern to the cache.