I have a delete problem in my java application. In my application at one place it have to delete multiple rows from a table which has 5 child tables.
The format of the DELETE statement is as follows:
DELETE FROM RESOURCE WHERE RESOURCE_ID IN (list_of_resourceIds).
The list of list_of_resourceIds size is 200 in number. We are using JDBC to do this. The records in the related child tables are deleting.
But, its taking more time(more than 3 minutes) which is longer than our weblogic time out. So the server is timing out.
Sometimes it’s taking up to 8 minutes also.
also we are have checked that Validation of referential constraints in child table is not causing problem from our DBA TEAM
The interesting thing to note here is the same group delete works very fast(normal behavior) most of the times.
Only sometimes it’s taking more time and hence my weblogic is timing out.
I looked into the code but couldn’t found any problem there. Because most of the times it’s finishing less than a minute.