Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (nike.apache.org: domain of jehanzeb.qayyum@gmail.com
 designates 209.85.216.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=LfCjiM/YwaJluU2g0L+f+GLBVn4H1cN83WZeF9QXa9wzsdSkZ94Toa2SLzAZc925x4
         eBjpSZ2J4Q9tnctwwwDyNwZrdFy+WDXJvafw4/1JFrKmmIa9EgOVu73y26AS0FjjkjXP
         rDxKoreBURH/5vru2wAaGte5XYxbhyXKp3i04=
MIME-Version: 1.0
In-Reply-To: <AANLkTikXEA3mmtE3r6IFP6FK8qhm_tctUf6IKvJ-Baso@mail.gmail.com>
References: <AANLkTinBsSWQm0DQOXIkEyx5VtLV1ACOXXj8tm2Ttod4@mail.gmail.com>
	<1497298471-1277877167-cardhu_decombobulator_blackberry.rim.net-297129890-@bda2253.bisx.produk.on.blackberry>
	<AANLkTilcXVvbJzubNFYVaAM1Az7KCzG0FoRGsfGPXzR8@mail.gmail.com>
	<AANLkTik9CE_W7MQgxqfIbRXpTqoadM1bQ1FN-AEiNUPA@mail.gmail.com>
	<AANLkTinDAtGlBoBCUUSp6yC5cIv-ZpTzlzfHL2ur9olC@mail.gmail.com>
	<AANLkTim4TeXpmgJH75huvVrfXqpDMrRjpbmc-LkzYMe1@mail.gmail.com>
	<318126678-1277892486-cardhu_decombobulator_blackberry.rim.net-1618933466-@bda2253.bisx.produk.on.blackberry>
	<AANLkTinCfm2toKdUc_CpS0zv7KEH9C2nLKeM_3iAHE1u@mail.gmail.com>
	<AANLkTikm4G58te72njOvCjaVI2z7Mr4tmc_eX49wWi0W@mail.gmail.com>
	<AANLkTin7GYPn8hAcu4AlWPwuB7lxC8n93L2ehQbaANzj@mail.gmail.com>
	<AANLkTikXEA3mmtE3r6IFP6FK8qhm_tctUf6IKvJ-Baso@mail.gmail.com>
From: jz <jehanzeb.qayyum@gmail.com>
Date: Wed, 30 Jun 2010 15:51:54 +0500
Message-ID: <AANLkTikNwnETQ4xkA71BcfTSNBqkCZXA9drzH4bKs5PK@mail.gmail.com>
Subject: Re: JMetere JDBC Test Confusing Result
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: multipart/alternative; boundary=00c09fa21e318a5876048a3d2528

--00c09fa21e318a5876048a3d2528
Content-Type: text/plain; charset=ISO-8859-1

This is exactly what i did.

I wanted to open all 10 connections before i do actual testing.

For this i added Thread Group 1 with 10 threads and a dummy select
statement. Now thread group 2 which has 100 threads, starts with a delay of
5 seconds. In those 5 seconds Thread Group 1 has opened all connections and
thread group 2 uses those opened connections only.

Regards,
Jehanzeb Qayyum


On Wed, Jun 30, 2010 at 3:45 PM, sebb <sebbaz@gmail.com> wrote:

> On 30/06/2010, sebb <sebbaz@gmail.com> wrote:
> > On 30/06/2010, jz <jehanzeb.qayyum@gmail.com> wrote:
> >
> > > Guys its a web applications. And connection pooling will be provided by
> >  >  container. I wanted to test only the time taken by query/stored
> procedure,
> >  >  not the time of spent in opening connection.
> >
> >
> > So don't use connection pooling in JMeter.
> >
> >  If you think about it, there will still be the same number of
> >  connections generated.
> >
> >  Either 10 in a pool, or 1 each in 10 threads.
> >
> >  Also, the connections are opened before the samplers run anyway.
>
> Actually, I'm not sure that is true; it's possible that the connection
> is opened on first use.
>
> In which case, just add a dummy select statement at the start of the test.
>
> Note that this may or may not work if you are using connection
> pooling, because the first samples in each thread may share a
> connection. In which case the first use (and connection open) may
> occur in the middle of testing.
>
> For repeatability, don't use pooling.
>
> >
> >  >  Regards,
> >  >  Jehanzeb Qayyum
> >  >
> >  >
> >  >
> >  >
> >  >
> >  >  On Wed, Jun 30, 2010 at 3:19 PM, sebb <sebbaz@gmail.com> wrote:
> >  >
> >  >  > On 30/06/2010, Sudip Kumar Bhattacharya <
> skb.subscriptions@gmail.com>
> >  >  > wrote:
> >  >  > > If it is a j2ee web application, app server wud be doing the
> connection
> >  >  > pooling.
> >  >  >
> >  >  > Yes, agreed.
> >  >  >
> >  >  > >  If it is a desktop app running from multiple terminals then
> connection
> >  >  > pooling won't be there across multiple users.
> >  >  >
> >  >  > Yes, agreed.
> >  >  >
> >  >  > >  I hope you are testing for a web application.
> >  >  >
> >  >  > If the OP wants to emulate the behaviour of a web application, then
> >  >  > they need to test using the pooling code actually used by the
> >  >  > applicaton, not the pooling code which happens to be used by
> JMeter.
> >  >  >
> >  >  > Note that the JMeter pooling implementation cannot be changed
> (except
> >  >  > by rewriting the code!).
> >  >  >
> >  >  > Alternatively, work out how many independent connections are
> created
> >  >  > by the web application, and use that many JMeter threads.
> >  >  >
> >  >
> >  > >
> ---------------------------------------------------------------------
> >  >  > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >  >  > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >  >  >
> >  >  >
> >  >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

--00c09fa21e318a5876048a3d2528--