db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Speeding up hideous insert
Date Wed, 04 Jul 2012 17:17:55 GMT
On 07/03/2012 03:20 PM, TXVanguard wrote:
> Don't worry too much about the details: just look at the SELECT DISTINCT,
> the WHERE, the GROUP BY, etc.  What are some general strategies for speeding
> up this kind of statement?

What the community knows about this sort of thing is mostly collected here:
http://db.apache.org/derby/docs/10.9/tuning/

A good place to start is to (a) break down your big query into smaller queries,
so you can analyze each part separately, and (b) learn how to read Derby's
query execution plan output, which you can read about here:
http://db.apache.org/derby/docs/10.9/tuning/ctundepth853133.html

thanks,

bryan


Mime
View raw message