openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "William Cai" <w...@xwarelabs.com>
Subject Performance declined dramatically during a series of delete operation
Date Fri, 16 Mar 2007 01:36:42 GMT
Hi list,
I've ran KODO/OpenJPA on Oracle for a while. It works well. But now I meet a
problem when executing a large series of delete operation 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, then delete it.
3. We will delete about 100,000 lines from the tables

Currently behavior:
First 1500 lines are deleted in about 1 second, but the later, the slower.
At last it takes 7 minutes to delete 200 lines.

Did anybody meet such a problem before? Please share your experience.

Thanks a lot!

William

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message