Working with results

The reason to build queries is to use the information they return to your Gosu program. Frequently you use items returned in result objects to display information in the user interface. For example, you might query the database for a list of doctors and display their names in a list. If you expect that the query will return more results than the user interface can display in a single page, you can set the page size to prefetch query results. Setting the page size is also useful if you want to use only the first few rows of a result set.