Hi All
I need help its urgent
I use EhCache as a secondry cache and the problem is that objects do resides in Cache and there is a significant performance achived.
The first time when we hit the application the response time is 30 sec which was expected.
The whole day users keep hitting the application and response time comes to 4 sec as against 30 sec when the application was directly hitting database.
Then in night nothing happens and then when in morning the first hit takes again 30 seconds.
I guessed that overnight the database connection becomes stale and that invalidates the Cache. Am I right
Also I have enabled the show_query=true.
Sometimes I can see that query is shown on console and sometimes I can see that it doesnt see and the values are retrived from Cache.
Viewing the cache stats I saw that there was no miss count as my users keep hitting the applications for same data.
Please can somebody explain me this behaviour and also the most important is what happens overnight that early in morning when user hits the first time the response is same as on the start of the application.

My objects are immutable and also dynamic_updates are set to false.

Thanks in advance
Rahul