Re: Apache Derby Poor Performance on select

2017-10-17 Thread sebb
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: http://db.apache.org/derby/ If they don't provide the

Apache Derby Poor Performance on select

2017-10-17 Thread Snigdhadeb Mukherjee
Folks, I don't know if this is the correct forum that I am asking the question on, 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 co