Business Issue : Form with multiple tabs taking long time to Open
Reason : One of block was having multiple Order by clauses and was picking all runs data ,
all data was not needed on initial form opening.
Solution : Get only recent run data at time of form opening , that will reduce the records to load.
Used onetime_where block property and populated it dynamically on WHEN_NEW_BLOCK_INSTANCE
SET_BLOCK_PROPERTY ('WB_BLK', onetime_where, l_where);
As name suggests onetime_where is appended to block query only once.
On F11 afterwards , regular where condition and supplied value is used by block query.
Reason : One of block was having multiple Order by clauses and was picking all runs data ,
all data was not needed on initial form opening.
Solution : Get only recent run data at time of form opening , that will reduce the records to load.
Used onetime_where block property and populated it dynamically on WHEN_NEW_BLOCK_INSTANCE
SET_BLOCK_PROPERTY ('WB_BLK', onetime_where, l_where);
As name suggests onetime_where is appended to block query only once.
On F11 afterwards , regular where condition and supplied value is used by block query.
No comments:
Post a Comment