Hello, I am working on legacy hibernate application and noticed that post querying the selects of huge data, the application code is flushing and clearing secondary cache. Now, the subsequent request is again taking the same time as first request.
Let me know if flush and clear of EM also clears secondary cache?
That does only clear the first level cache. You should enable Hibernate statistics as well as the cache region logging to see how effective the cache is.