community-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
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
<snigdhadeb.mukherjee@live.com> 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:
http://db.apache.org/derby/

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
unique.
>
> 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: dev-unsubscribe@community.apache.org
For additional commands, e-mail: dev-help@community.apache.org


Mime
View raw message