jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ondrej Ivanič <ondrej.iva...@gmail.com>
Subject JDBC sampler very slow
Date Wed, 06 Oct 2010 22:01:40 GMT
Hi,

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

Thanks,
-- 
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


Mime
View raw message