db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Karp <dk...@zimbra.com>
Subject Re: Derby perf bug?
Date Tue, 29 May 2007 14:05:21 GMT
> I am working with Derby 10.2.2.  This SQL query has an unacceptable
> performance:
> 
> SELECT * FROM registryobject WHERE id IN (SELECT targetObject FROM
> association WHERE UPPER(sourceobject) = UPPER(?))
> 
> Is this a bug in derby or something else?  Am I missing something?

https://issues.apache.org/jira/browse/DERBY-47

Fixed in 10.3.0.0.

Mime
View raw message