I have an Oracle table to store some messages user (let’s says between 100 and 300 records).
Many of my flow services read and use these data… but these data do not change once they are inserted in the table (that data are like constants).
I made a service Adapter to access these data… but, the query has a cost in terme of performance…
Is there any way to put these data in cache (in the IS memory) , to avoid WebMethods in accessing them each time from the Oracle Server ?
(I’m looking for a solution without the Terracotta product, I do not have)