Thanks for your response...
I have tried to adjust fetchsize and cursor block size ,but the improvement is very insignificant...
So i think maybe the problem is not on database side,
maybe the java object create and convert ( eg, rs.getdate will create a new date object)
consumed most of the time.
maybe i should ask some guys who are familiar with java。
But the smartest thing might be to consider alternative ways to handle bulk data (if performance is your main focus).
I agree with db2mor.
I'm interesting how fengsun2 want to handle the bulk data after retrieving through cursor.
If write to a file to pass it to other program(s), EXPORT might be better.
If do some calculations and/or sum up them, do most of them in an SQL might be better.
We need to passed each fetched row to another subsystem.
which used the tools called rule engine。
It support to use very complex rules to proccess each rows 。
And the tool provide a GUI which can used directly by user to
configure the rules.