IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Does Terracotta (TSA) use disk-based index for BigMemory SQL queries?

  • 1.  Does Terracotta (TSA) use disk-based index for BigMemory SQL queries?

    Posted Tue June 13, 2017 03:01 AM

    Hi,

    As you are aware, we can use BigMemory SQL (either using ANSI standard SQL or through Query API) over Terracotta caches (including distributed).

    For these SQL queries, does Terracotta use disk-based indexes for Searchable caches? Or are these indexes also stored in cache (L2, if TSA is being used)?

    Thank you.


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


Related Content