db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: derby is hanging in org.apache.derby.exe....g2
Date Thu, 01 Nov 2012 00:38:56 GMT
>                 "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?

Mime
View raw message