db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From degenaro <lou.degen...@gmail.com>
Subject Re: slow query? (from a practical newbie)
Date Tue, 07 Jan 2014 20:52:08 GMT
Bryan Pendleton-3 wrote
> Are the queries that we're discussing here running slowly for you?

Yes, very slow.  With about 50,000 rows the query takes about 30 seconds
give or take.  But if I remove the where clause, the time is sub second.


View this message in context: http://apache-database.10148.n7.nabble.com/slow-query-from-a-practical-newbie-tp136285p136327.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message