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 (athena.apache.org: domain of ondrej.ivanic@gmail.com
 designates 74.125.82.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=s0FqdIFXa8dM2jcpdPhXiJ+8muz/N4s0YEqVhzRJjk/2pThnQIDE1EMXp/5bhAtauN
         lGaS6U92KUhQRuMsx1vk0LPB15YsholYTzmoceYr8yfLW9sNzxl6mQJ079qQdkvVWULd
         zyWdaTHhndps8OROlMvnkTZmwVJFazKKA9PXQ=
MIME-Version: 1.0
In-Reply-To: <4CAD7553.9000601@mpexnet.de>
References: <AANLkTikf1xJCipBqMOR7gd7N48q9+=07KFtsjQgrK3XS@mail.gmail.com>
	<4CAD7553.9000601@mpexnet.de>
Date: Fri, 8 Oct 2010 15:38:10 +1100
Message-ID: <AANLkTi=LfivcuQQRusXhS=X7ahzVrWVwyRTguUDvhczc@mail.gmail.com>
Subject: Re: JDBC sampler very slow
From: =?UTF-8?Q?Ondrej_Ivani=C4=8D?= <ondrej.ivanic@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: text/plain; charset=UTF-8

Hi,

I do not care about network perforce in this test because I want to
test database server as is. Using JDBC sampler I can't fetch more than
100 rows. I think i'll just write simple PHP script which executes all
that queries using 'ab' (Apache HTTP server benchmarking tool) and
OpenOffice to get some reliable results and fancy charts :)

On Thu, Oct 7, 2010 at 6:22 PM, Felix Frank <ff@mpexnet.de> wrote:
>> Part of the database benchark (Postgres 8.4, recent JDBC4 Postgresql
>> Driver) is query which fetches 1000 recent events (row size is ~1k so
>> 1mb of data in total):
>>
>> select * from event order by datetime desc limit 1000
>>
>> When query is executed using JDBC sampler it takes between 2 and 5
>> minutes to finish comparing to less than 50ms using psql or simple PHP
>> script. I suspec that value of JDBC fetch size parameter is set too
>> low. Is it possible to change this parameter?
>>
>> I found the following workaround:
>> explain analyze select * from event order by datetime desc limit 1000
>> which executes query (analyze = carry out the command and show the
>> actual run times) on the server and query result is discarded. The
>> question is if test is still reliable...
>
> Hi,
>
> this question reminds me of discussions we had here about whether images
> and static content should be included in web tests or not.
>
> The answers were "yes", "no", "maybe" and "it depends", in no particular
> order or prioritization.


-- 
Ondrej Ivanic
(ondrej.ivanic@gmail.com)

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