Friday, August 10, 2018

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.




 

No comments:

Post a Comment