Portage Bay
Solutions
Portage Bay

PSOS

A Perfect Pair - ExecuteSQL and PSOS

A Perfect Pair - ExecuteSQL and PSOS

This is a quick tip about how PSOS can vastly improve performance of the ExecuteSQL script step.  Recently we received feedback on one of our solutions that uses Execute SQL to build a virtual list used in a picker window. The feedback had to do with the slow performance of loading the picker window. The user complained of the window sometimes taking up to 30 minutes to load. Obviously this design was not ideal!