AnsweredAssumed Answered

Make sense to use SQL query instead of a relationship?

Question asked by KurtBleicken on Feb 9, 2016
Latest reply on Feb 11, 2016 by KurtBleicken

Our application is designed for Webdirect deployment.

 

Using the ListOf function we are finding a list of primary keys of a found set. Then parsing that list into groups of 20. Using the g_ListOf global in a relationship to the original found set in a separate TO to bring up the first 20 records. Then advancing the page number to go to the next set of 20 records.

2016-02-09_14-48-28.png

All is well, works perfectly.  But . . . it is very slow. in Webdirect.  2 seconds or more to move to the next set of 20. I'm wondering if there is a way to use the list of 20 primary keys stored in the global g_ListOf in setting up a SQL query as an array to pull up the 20 records. I have no idea as to how to do this. Or if it would execute faster.

Outcomes