Generally SQL can't faster than native ways.
What is the slowness in your steps?
Do you really need to get ListOf every time to move page?
Only get ListOf one time, move to next page by resetting the page number to change the pattern count.
Found the problem!!! I was using a relationship from Users > Alums > AlumsGListOf where the global GlistOf was set with a search in the Alums table. Then the global was used as the relationship to the TO AlumsGlistOf.
My mistake was using Users in the relationship. Dropped the first Users table so the relationship was from Alums > AlumsGListOf. The difference was dramatic.
Moving from set to set before was taking 1.5 seconds per move.
Using the new relationship, the move between sets is now as fast as I can click a mouse.