Hi peter
Thanks for your reply.
I didnt get what u meant by testing it with bean
What I did was
recorded the time before I executed the Proc
recorded the time after I got result result set
recorded the time after commenting all the logic I had in
while(rs.next()){} loop.
I need all 6000 rows coz
on my page i am selecting one item in my combo-box and based on value i select second combo box on same page gets populated.
Unfortunately there is one value which is creating problem
Any help will be of great help 2 me
On Fri, 21 Feb 2003 Peter Lin wrote :
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
