Canvas Apps Performance

How to optimize fetching multiple records from a table

A lot of times you would want to lookup multiple records from a table. Would you do that one at a time or is there a better way to do it?