I need a little help with a design decision.

Is it better to pull all of the records of a remote table into a cursor at the start of an app and use that cursor to view, update, etc...?

Or is it a better design to SPT each record as needed?