db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Performance issue of derby using JDBC
Date Mon, 15 Dec 2008 18:53:39 GMT
Harshad wrote:
>   "select name,version,release,time from PKG where PKG.id in (select id from PROVIDES
where name = ?)",

What happens if you run this statement instead:

select pkg.name,pkg.version,pkg.release,pkg.time from pkg, provides
        where pkg.id = provides.id and provides.name = ?

thanks,

bryan


Mime
View raw message