The view designer has things you can get to from the advanced options bar on the query menu that can limit the number of records fetched at any one time. I don't know the syntax for doing this with SPT but you may be able either just use a view or run GENDBC for a view configured like this and look at the DBSETPROP calls for a clue.

Dick