Both ResultSet and Statement have the SetFetchSize method. When used in the Statement all of the ResultSets returned by that Statement will have the same fetch size.
SetFetchSize determines the amount of data blocks or rows that should be carried to the client from the server after executing a statement.
Advantanges of using setFetchSize().
I did a comparitive study aout the impact of setting the fetch size when executing a query that resulted in about 1k records.
DB: Oracle 10g
Driver: oracle thin
Java version: 5
The database server was not in the local network.
| FetchSize | Time in entire processing: |
| Default:0 | 31897ms |
| 10 | 31476ms |
| 100 | 6858ms |
| 500 | 5514ms |
The advantage is self evident.
No comments:
Post a Comment