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 <[email protected]> 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 ([email protected]) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
