This discussion is archived
5 Replies Latest reply: Mar 5, 2013 10:30 PM by gauravnankar RSS

Row-wise Initialization: Use caching

gauravnankar Explorer
Currently Being Moderated
We have the 'Use Caching' check box available for row-wise initialized system variables. Although I do understand how this is useful as it shortens the login time for users who have logged in before by initializing the session variable from the cache instead of firing the query on the database everytime, I need to understand how this cache mechanism works especially when the overall server caching is disabled.

I have faced a situation where the session variable was initialized from the cache although the server caching was disabled. Is there any way to purge this cache or set a refresh frequency? As of now I had to uncheck the 'Use Caching' check box to fetch the refreshed results in the session variable. But I believe this is undesirable in the long term.

Thanks,
Gaurav

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points