db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Doran <matt.do...@papercut.com>
Subject Re: Pathologically poor query performance - advice required
Date Fri, 27 Jun 2008 00:41:47 GMT

> To get feedback from people it may also help to post the ddl of the 
> tables in the query, including the indexes/constraints.  I know you
> provided the db, so with work it is available - but the more up front
> info you provide the more help possible.
I've attached the database creation script if anyone is interested.
>
> One other suggestion might be to try the query once with no optimizer
> timeout to see if it would have found a better plan:
> http://wiki.apache.org/db-derby/PerformanceDiagnosisTips
>
I tried disabling the optimizer timeout, it had not effect.  It was the 
maxMemoryPerTable that had the impact here.

Thanks,
Matt



Mime
View raw message