Using JDBC to asynchronously read large Oracle table
- by Ben George
What strategies can be used to read every row in a large Oracle table, only once, but as fast as possible with JDBC & Java ?
Consider that each row has non-trivial amounts of data (30 columns, including large text in some columns).
Some strategies I can think of are:
Single thread and read table. (Too slow, but listed for clarity)
Read the…