Looks like either your network connection is super slow, or your oracle is not optimized at all.
if it is oracle, go to amazon.com, buy yourself an oracle performance tuning book :) it is the fastest return on investment you will ever see. nothing to do with tomcat. Filip -----Original Message----- From: vikas yk [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:43 PM To: [EMAIL PROTECTED] Subject: Performance Issue 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
