Forum Stats

  • 3,768,482 Users
  • 2,252,799 Discussions
  • 7,874,596 Comments

Discussions

How to stop initial loading data of an Interactive Grid?

John like many others
John like many others Member Posts: 107 Red Ribbon
edited Aug 13, 2020 9:13AM in APEX Discussions

Hello

I have a mask with an Interactive Grid taking 15-20 seconds to load. The grid as some popup LOVs (with SQL statements as source, all pretty fast) and one of them seems to be the cause of the slow loading. I assume Apex will execute the SQL behind of the LOVs for EACH row which is of course very inefficient. As the user has a search bar he does not need to see some pre-loaded data in the GRID on starting up the mask. So if it would be possible not to load data into Grid on starting mask that would be great. I already tried to the attribute option "Lazy loading" but that doesn't help at all (no performance improvement). Any other ideas how to avoid loading data on starting up mask?

Thank you in advance for any hint.

Answers