WebSphere

User Group UK

Looking for up-to-date content? Check out IBM's WebSphere, Liberty, Java & DevOps Community, as well as @wasdevnet and @openlibertyio on Twitter!


Title:
Efficient, scalable caching using ESQL shared variables in Message Broker V7, V8 and IBM Integration Bus V9
Stream:
179
Speakers:
Gerardo Brenner
Abstract:
This session will describe a novel way of improving the performance and scalability of local caches enabling much larger cache sizes to be implemented efficiently in MB and IIB.ESQL shared variables are commonly used to cache database table contents and are usually implemented as an array containing the result of a SELECT operation. Searching the cache consists of issuing a SELECT against the array but because ofthe sequential nature of this search, as the cache grows, the search takes longer such that most users have found that at cache sizes of more than a few thousand rows, it is faster to access the database rather than the cache.This session demonstrates a novel way of structuring the cache that scales well, and remains faster than DB access even when the cache is larger than 10K rows.The new cache structure is transparent to applications, so existing caches can be safely converted, potentially resulting in significant reductions in response time and CPU usage and has been successfully demonstrated with two customers, both with large Message Broker installations.The session also includes a comparison with the new Global Cache capability.