db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Husek, Paul" <Paul.Hu...@pfizer.com>
Subject inefficient doDelete
Date Fri, 11 Mar 2005 16:01:45 GMT
I've been using Torque for almost a year now and am very happy with it.
Recently though I found something that confuses me.  

 

All along I've been deleting all History books like:

 

Criteria c=new Criteria();

c.add(BookPeer.TYPE,"HISTORY");

BookPeer.doDelete(c)

 

And it works fine.  But recently I tried this when there over 100,000
history books.   I was greeted with a java "out of memory" error.  Is Torque
trying to load all records before deleting each of them?  Why would it?  Is
there a work around?

 

Thanks,

 

Paul

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message