rset.next() takes long time for 11000 rows.

I am using informix database and trying to retrieve 11000 records with 19 columns which I think is taking long time(like my whole program is taking 16 min of which rset.next() is taking more time). Query is executed pretty fast but rset.next() is like I can notice the time its taking to be done. Can you suggest some ways to make this retreive fast?

i don't know what settings you already have but here are some general tips:
1. play with the setFetchSize(int i); method to optimize large resultsets
2. Do not use a scrollable resultset. They are slower.
3. set the connection transaction isolation level to the lowest possible setting without compromising data integrity:
setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED);
you might get some more bites in the performance forum.
Jamie

I already set my block size while fetching the data.
What is a scrollable resultset?
I am just using a simple query and not using any stored procedures or triggers to set the autocommit.(i read it on internet)
[This message has been edited by saroja dendukuri (edited August 09, 2001).]

scrollable: allows you to move forwards, backwards and to any absolute position in the resultset. If you haven't explicitly declared it in your statement then the default is TYPE_FORWARD_ONLY(which is faster when iterating through a resultset).
Jamie