JDBC - speed with big 'select's

Hi,

Having just read the results of the post concerning INSERT times, I thought
I should ask a related question that has been causing me some problems.

I have a servlet which performs a SELECT which returns up to 6000 rows.
These contain just 6 ints and need to be read to perform a specialised
search. The query run's pretty quick, less than a second (although the time
to display is much longer), using the psql interface. Therefore I assume the
majority of the time the servlet requires is repeated calls to rs.next() and
then the requests for each of the fields across the socket connection.

JDBC 2.0 has a setFetchSize() function which looks as though it may allow me
to transfer the results in larger chunks, but I am shooting in the dark
really.

Any suggestions as how I might speed this whole thing up, the INSERT trick
by using COPY FROM STDIN got me thinking there may be other alternatives.
Unfortunately I can not perform the selection using a more selective SELECT
statement.

Many thanks in advance

Simon

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Simon Hardingham - netXtra Ltd - UK _/
_/ Tel: +44 (0) 1787 319393 Fax: +44 (0) 1787 319394 _/
_/ http://www.netxtra.co.uk simon(at)netxtra(dot)co(dot)uk _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/