Tune your queries and schemas to ensure that you do not waste network resources and memory by selecting unneeded data. For example, do not select 100 rows, then search them in your component to find the one row that you need. Use the query language to direct the database to find and return only the data you need. In EJB entity beans, implement additional finder methods to allow results filtering with database query language rather than returning many rows to be filtered on the client.
In CORBA components that return large result sets to the client, you may get better performance by batching the result set into smaller groups of rows, then reassembling them on the client. Doing so avoids the need to construct large TabularResults.ResultSet objects in memory.
