4 Replies Latest reply on Feb 11, 2016 10:39 AM by KurtBleicken

    Make sense to use SQL query instead of a relationship?


      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.


      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.