skip to main content
Designing JDBC Applications for Performance Optimization : Returning Data : Reducing the Size of Returned Data

Try DataDirect Drivers Now

Reducing the Size of Returned Data

Sometimes long data must be returned. When this is the case, remember that most users do not want to see 100 KB, or more, of text on the screen.
To reduce network traffic and improve performance, you can reduce the size of any data being returned to some manageable limit by calling setMaxRows(), setMaxFieldSize(), and the driver-specific setFetchSize(). Another method of reducing the size of the data being returned is to decrease the column size.
In addition, be careful to return only the rows you need. If you return five columns when you only need two columns, performance is decreased, especially if the unnecessary rows include long data.