Return-Path: 
 <torque-user-return-5894-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 73512 invoked from network); 11 Mar 2005 16:03:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 11 Mar 2005 16:03:16 -0000
Received: (qmail 17313 invoked by uid 500); 11 Mar 2005 16:03:14 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 17289 invoked by uid 500); 11 Mar 2005 16:03:14 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 17276 invoked by uid 99); 11 Mar 2005 16:03:14 -0000
X-ASF-Spam-Status: No, hits=3.2 required=10.0
	tests=DNS_FROM_RFC_POST,HTML_MESSAGE,RCVD_IN_BL_SPAMCOP_NET
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from mail-red.bigfish.com (HELO mail69-R-red.bigfish.com)
 (216.148.222.61)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 11 Mar 2005 08:03:12 -0800
Received: from mail69-red.bigfish.com (localhost.localdomain [127.0.0.1])
	by mail69-R-red.bigfish.com (Postfix) with ESMTP id CBEBA3C0008
	for <torque-user@db.apache.org>; Fri, 11 Mar 2005 16:03:08 +0000 (UCT)
X-BigFish: VPC
Received: by mail69-red (MessageSwitch) id 1110556988741112_5158;
 Fri, 11 Mar 2005 16:03:08 +0000 (UCT)
Received: from mailrelay5.pfizer.com (ns11.pfizer.com [192.77.198.11])
	by mail69-red.bigfish.com (Postfix) with ESMTP id 7B39D3BF4E7
	for <torque-user@db.apache.org>; Fri, 11 Mar 2005 16:03:08 +0000 (UCT)
Received: from nycexpf06.pfizer.com (localhost [127.0.0.1])
	by mailrelay5.pfizer.com (Switch-3.0.5/Switch-3.0.0) with ESMTP id
 j2BG37UE008606
	for <torque-user@db.apache.org>; Fri, 11 Mar 2005 11:03:08 -0500 (EST)
Received: by nycexpf06.pfizer.com with Internet Mail Service (5.5.2655.55)
	id <ZB1MK0Q8>; Fri, 11 Mar 2005 11:03:07 -0500
Message-ID: <1592218F4C3EED4FBEAC48F9160FE60F15E7941F@nycexmb09.pfizer.com>
From: "Husek, Paul" <Paul.Husek@pfizer.com>
To: torque-user@db.apache.org
Subject: inefficient doDelete
Date: Fri, 11 Mar 2005 11:01:45 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2655.55)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C52653.9FCBC5C0"
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C52653.9FCBC5C0
Content-Type: text/plain

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

 

 

 


------_=_NextPart_001_01C52653.9FCBC5C0--