community-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <>
Subject Re: Apache Derby Poor Performance on select
Date Tue, 17 Oct 2017 14:46:33 GMT
On 17 October 2017 at 14:58, Snigdhadeb Mukherjee
<> wrote:
> Folks,
> I don't know if this is the correct forum that I am asking the question on,

Please address your query to the Apache Derby community.

There are links to tutorials etc here:

If they don't provide the answer, please subscribe to the Derby user
list and ask there.

> but I am at my wit's end and I need to be able to get this working quick.
> The scenario:
> Apache Derby 10.13, Jdk 8u 11x, RHEL, 64bit, 8 cores
> The table is not indexed and contains 25million rows. Select is by a column that is not
> Derby started in network server and jdbc URL is for in memory dB to the network server.
> Select takes 10 secs even for 3 rows result set
> JVM started with 5gb Mx
> Regards,
> Snig

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message