db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: Efficient way to delete lots of rows at a time?
Date Wed, 06 Feb 2008 20:23:42 GMT
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 there a better
> option than this? 

The library under the hood of Torque - Village - is responsible for this 
behaviour. There is BasePeer.deleteAll() to circumvent this limitation, 
clumsy as it may be. We promise improvement for version 4.0.

Bye, Thomas.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message