Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: open-jpa-dev@incubator.apache.org
Received-SPF: pass (herse.apache.org: domain of plinskey@bea.com designates
 66.248.192.22 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Performance declined dramatically during a series of delete
 operation
Date: Fri, 16 Mar 2007 03:43:19 -0700
Message-ID: <7D856CDFE035FF45A0420ACBD71BDD63038613CC@repbex02.amer.bea.com>
In-Reply-To: <fb731ec20703151836n7958effcg17d1b45fe6a13a47@mail.gmail.com>
Thread-Topic: Performance declined dramatically during a series of delete
 operation
Thread-Index: Acdna57Bue8CJksVT3+pjoYEKPKmvwATCs+Q
References: <fb731ec20703151836n7958effcg17d1b45fe6a13a47@mail.gmail.com>
From: "Patrick Linskey" <plinskey@bea.com>
To: <open-jpa-dev@incubator.apache.org>

Have you tried incrementally calling EM.flush() during the course of
your transaction? Also, for deleting that many records, you may want to
look at using JPQL's bulk delete APIs.

-Patrick

--=20
Patrick Linskey
BEA Systems, Inc.=20

_______________________________________________________________________
Notice:  This email message, together with any attachments, may contain
information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated
entities,  that may be confidential,  proprietary,  copyrighted  and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.=20

> -----Original Message-----
> From: William Cai [mailto:wcai@xwarelabs.com]=20
> Sent: Thursday, March 15, 2007 6:37 PM
> To: open-jpa-dev@incubator.apache.org
> Subject: Performance declined dramatically during a series of=20
> delete operation
>=20
> Hi list,
> I've ran KODO/OpenJPA on Oracle for a while. It works well.=20
> But now I meet a
> problem when executing a large series of delete operation=20
> with it -- the
> performance is declined dramatically.
> The scenario is like below,
> 1. About 40 tables, and there are some external references among those
> tables.
> 2. The operation queries if the target data exist, if yes,=20
> then delete it.
> 3. We will delete about 100,000 lines from the tables
>=20
> Currently behavior:
> First 1500 lines are deleted in about 1 second, but the=20
> later, the slower.
> At last it takes 7 minutes to delete 200 lines.
>=20
> Did anybody meet such a problem before? Please share your experience.
>=20
> Thanks a lot!
>=20
> William
>=20