Performance Issue

[vikas yk <vi...@rediffmail.com>]

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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: Performance Issue

[Peter Lin <tc...@yahoo.com>]

 
If you're reading out 6K rows remotely, you're limited by bandwidth. Especially if the webserver only has one ethernet card and you're viewing the pages from another client. If you're concerned about performance, I would suggest writing a simple test bean to do the same exact query and time the elapse time to get the data. Then you can subtract the transport time from the total elapsed time.
Is there a reason you need all 6000 rows? That's a lot of data to view in one shot. If you can break it into pages, or preload that data, it should improve the response time.
 
peter
 
 vikas yk <vi...@rediffmail.com> wrote: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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org



---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

Re: Performance Issue

[Andrea Papotti <pa...@adigitali.it>]

At 04.42 21/02/2003 +0000, you wrote:

>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.

are you really sure that the time is spent in the rs.next() loop;
try to remove the loop and check timings.
Seems to me that the time depends on storage of data in memory (only a 
feeling, but...)

my 2 cents opinion.

Andy 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org