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
