If I want to remove a bunch of records from a table I would do a "delete from table where id=xxx". If I want to accomplish the same task using a CMP.I need to do a finderMethod(id) which gives me an enumeration of EntityBeans and on each of those EBs I call a remove. This involves n+1 queries, one to do a finder and the other n to fire a delete for each record. This is clearly inefficient both interms of getting n beans into memory and the database round trips. Is there a better alternative? regs Venkat =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
