db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <qoz...@gmail.com>
Subject Re: question about Derby property and hash joins
Date Thu, 01 Feb 2007 17:12:57 GMT
Jason Boehle wrote:
> The 10.2 tuning document says:
> 
> "If memory use is not a problem for your environment, set this property
> to a high number; allowing the optimizer the maximum flexibility in 
> considering a join strategy queries involving large queries leads to 
> better performance.
> 
> What Derby property is it talking about, that represents the system-wide
> limit of memory use for a table?

The property name is "derby.language.maxMemoryPerTable".  There is an existing 
Jira issue for this particular documentation error: see DERBY-1397.  If you plan 
to use the property it might be good to read the comments posted to that 
issue--there is some discussion of what the max/min values are and what happens 
if you specify an invalid value.  There is also a proposal for what should be 
added to the documentation regarding that property...

Army


Mime
View raw message