Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Message-ID: <127801c2d9ce$394b4600$01000001@Will>
From: "Will Hartung" <willh@msoft.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>,
	"vikas  yk" <viksy2k@rediffmail.com>
References: <20030221105215.20305.qmail@webmail18.rediffmail.com>
Subject: Re: Re: Performance Issue
Date: Fri, 21 Feb 2003 09:25:26 -0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Another thing you can try is to time how long it takes to get the FIRST
record, rather than the entire thing. Sometimes the actual result set is
fully realized until after the first row is fetched.

Once the result set is realized on Oracle, fetching should be pretty quick.

Regards,

Will Hartung
(willh@msoft.com)

----- Original Message -----
From: "vikas yk" <viksy2k@rediffmail.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Friday, February 21, 2003 2:52 AM
Subject: Re: Re: Performance Issue


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


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