This content has been marked as final. Show 5 replies
Please tell us your jdev version...
What do you mean by
...whenever the user launched the page the countryVO query is executed again and again and it is not cached.Do you see the query executed multiple times for the same page (without the LOC being inside a table)?
Or once per page load?
Where is LOV located?
Our jdev version is 18.104.22.168
We have the page which shows the department table each record has the country LOV.
After the login the user can view the page at that time the query is executed, after that he may visit some other page and then come back to the same page then again it is executed. The CountryVO list is based on the language so it needs to be load only once per session in my case to optimize the performance.