db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vitzethum, Daniel" <Daniel.Vitzet...@gigatronik.com>
Subject AW: inefficient doDelete
Date Mon, 14 Mar 2005 14:50:29 GMT
Hello Paul,

> How are people handling this? 

as already mentioned by someone else (Thomas?), I suppose you
could/should
delegate it to the database with a custom sql, e.g.

  BasePeer.executeStatement("DELETE FROM " + FooPeer.TABLE_NAME + "
WHERE " + FooPeer.A_COLUMN + "=1");

That wouldn't load all records and use the performance of the DB for
large amounts of data.


HTH,

Daniel

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


Mime
View raw message