db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Question on benchmarks on derby.
Date Mon, 03 Sep 2007 15:01:02 GMT
> We have tried TPC-W on Derby 10.2.2(server mode) and was not a viable teste.

Have you tried Derby 10.3, which was just released? It would be interesting
to know how the results compared.

> This test have many IN  statements with multilevel querys and max rows
> statements. The optimizer doesn't make the best choices, there are
> many table scans over indexed columns.  And have some memory leak. So

I'm sure that the developers list would be quite interested in
discussing the problems that you found, and the possible solutions
that you think would be useful. Sounds like you may be hitting some
known problems, but may also have encountered some new ones.

What is your goal with respect to running these benchmarks? Are you
attempting to evaluate whether Derby's performance would be acceptable
for your environment? Or are you investigating Derby performance
issues in order to address them?



View raw message