On 17 October 2017 at 14:58, Snigdhadeb Mukherjee <snigdhadeb.mukher...@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-unsubscr...@community.apache.org For additional commands, e-mail: dev-h...@community.apache.org
