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.