I need help with a performance problem we´re having. We have to delete all of the records in two tables in our database based on a certain criteria. Because these tables have (BMP) entity beans associated with them, we create each bean and then delete it with remove(). Typically there are 40 - 60 beans in each table that need to be removed, and this step is definitely the bottle-neck in the process. Could we go about this in a different, more efficient way?
A colleague commented that in Weblogic there´s something called "read-only multicast invalidation" that allows you to invalidate all of the entity beans of a certain type and force them to reload. Does anything like this exist in JBoss 3.0.0?