Re: Efficient way to delete lots of rows at a time?

brainville wrote: What I have noticed, though, is that the doDelete method seems to be performing a select, then executing a separate delete statement for each returned row. In one specific example, there are 12000 people that belong to a category -- that's 12000 separate delete statements. Is

Efficient way to delete lots of rows at a time?

ption than this? CategoryMapPeer.executeStatement("delete from " + CategoryMapPeer.TABLE_NAME + " where " + CategoryMapPeer.FK_CATEGORY_ID + " = '" + categoryId + "'"); Thanks.. Ben Rainville -- View this message in context: http://www.nabble.com/Efficient-wa