Deleting rows from a database table having foreign key constraints using BMP with Jboss as server
Posted on 2006-04-07
i have two tables TabA and TabB. TabA is the parent table and TabB is the child table. A column in the TabB references Primary key in the TabA.
TabA contains 3000 rows
TabB contains 10 rows for each row in TabA sp total of 30,000 rows
I am using BMP EJB to delete the rows from the two tables, first i have deleted the rows from the TabB..
it took 600 milli seconds
Now when i delete the rows from TabA (parent) it is consuming 4 minutes..... which is very high...
later i tried to do the same thing by droping the foreign - key constraint form the database.
i.e i have dropped the foreign-key constraint TabB refers TabA.
Now the delete is happening in 1 second..
i think there might be some settings in the JBoss which is causing this delay... in the case of foreign-key constraints.