Hey Paul,
Just wanted to let you know the App Development team came back to me saying the pagination is lightning fast using the TOP (@var) approach. They are going to go ahead and start implementing this as a pilot project.
Thanks for the informative article and eagerly waiting for the next one's 🙂
Amol Naik