You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Bryan Pendleton <bp...@gmail.com> on 2012/11/01 01:38:56 UTC

Re: derby is hanging in org.apache.derby.exe....g2

>                 "DELETE FROM ConnectionEntity conn WHERE conn.stopOrPass.id IN " +
>                     "(SELECT sop.id FROM StopOrPassEntity sop WHERE sop.partialTrip.id IN " +
>                     "(SELECT prtTrip.id FROM PartialTripEntity prtTrip WHERE prtTrip.trip.id IN : Ids))"

There have been performance problems in the past with IN (...) queries.

Is this query under your control? Or is it generated by some tool?