Performance Issue

[vikas yk]

I am making call Oracle Function on remote database .
The values are taken in result set.The numbers of records in result set are aroung 6000.
when I do
while(rs.next())
{
//My logic
}
This takes aroung 5 min(300 sec) to get completed
Now I commented all my logic inside while loop of rs.next()

then also its taking around 4 min (250 sec) to just loop through records.
Is there any way I can minize my time to recurse through records.

I am using oracle thin driver to make connection.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]