Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Sat, 22 Oct 2011 13:26:32 +0000 (UTC)
From: "Moti Nisenson (Created) (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: 
 <285472756.5223.1319289992006.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (OPENJPA-2062) Poor performance for JPQL delete
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Poor performance for JPQL delete
--------------------------------

                 Key: OPENJPA-2062
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2062
             Project: OpenJPA
          Issue Type: Bug
          Components: jpa
    Affects Versions: 2.0.1
         Environment: Derby 10.5.3
            Reporter: Moti Nisenson


If I have a simple entity as such

@Entity
public class MyClass {
   @Id
   Long id;
   
   @Column(name="xyz", nullable=false)
   Long field;
}

And I have a JPQL delete query: "delete from MyClass e where e.field=?1"
this gets translated into the following sql: DELETE from MyClass where id in (select distinct t0.id from MyClass t0 where (to.xyz = ?))

The extra select with distinct (rather than just having DELETE from MyClass where xyz=?) causes a big performance slowdown; on the order of 5-10x (with Derby 10.5.3).

I didn't bother testing for different annotations, but I would imaging it's the same for all of them.

Please fix this; it is very basic functionality and the SQL generated should be the straightforward, high performing version.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira