Question
JPMC
IN
Last activity: 11 Mar 2025 7:17 EDT
When switching user saved views DB is getting hit without considering loading mechanism
Hi Everyone,
I have configured a UI with display of table sourcing from Data Page which has loading mechanism of every four hours with Personalize Table option enabled in table configuration.
When user is launching the UI first time - system is referring the data page and running the query which is configured in data source of data page.
The same query is getting hit again when user is trying to switch view that has been saved earlier even though 4 hours timeframe is not met...!
Can we get rid of having the DB query hit within 4 hours time frame when switching the views ?
Accepted Solution
Updated: 11 Mar 2025 7:17 EDT
JPMC
IN
@purit Thanks Tanya for your inputs. Just to summarize
Pega hits the load management logic of data page when switching the views for first time irrespective of load management.
Post the initial load of data page respective to each view, then load management comes into picture and reloads if older than specified time interval.
Pega
IN
@SanthoshRanga Hi Santhosh, As we discussed earlier, This is the Expected behaviour of the system. When we create a new session by logging in into the Environment and switch between the Custom Views of the gird, at first, new clipboard instances are getting created for each view for the first time. Also, DB query is getting triggered for the first time when switching between Views because every view has different query generated at backend. Later, when we are switching the Views No DB query is getting triggered as it will take data from cache. This functionality is independent of the Load Management which is set to 4 hours in your case. Load Management comes into picture when we have Active session for the same time and when that time past then Load management triggers and data is refreshed. Thank You
Accepted Solution
Updated: 11 Mar 2025 7:17 EDT
JPMC
IN
@purit Thanks Tanya for your inputs. Just to summarize
Pega hits the load management logic of data page when switching the views for first time irrespective of load management.
Post the initial load of data page respective to each view, then load management comes into picture and reloads if older than specified time interval.