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.
