Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of xuhua.lin@gmail.com
 designates 64.233.170.198 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=oeRo9NPGGhKNYwqWqac2z+14qzcdUJYURXd4qBukLaVvVDt3UvTlSqlVPR+VghLFM6oCWXbsaT+Xvlh8bLI+vG974X1PzRTYeAOPxx+i2bSoBUZZUmTFCnMnZbsGYcOTkVeVyl0/YLNnsRN8/wX/WPPY+cDR4eLEgZNR65uJyK0
Message-ID: <37d34e6b041015104130be9a52@mail.gmail.com>
Date: Fri, 15 Oct 2004 13:41:42 -0400
From: Howard Lin <xuhua.lin@gmail.com>
Reply-To: Howard Lin <xuhua.lin@gmail.com>
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Back to back save is slow
In-Reply-To: <1592218F4C3EED4FBEAC48F9160FE60F1182CE65@nycexmb09.pfizer.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <1592218F4C3EED4FBEAC48F9160FE60F1182CE65@nycexmb09.pfizer.com>

One alternative is to use JDBC batch insert/update to reduce trips to
database. You have to build your own prepared statement for this,
though. (not Torque)

Howard


On Fri, 15 Oct 2004 12:58:55 -0400, Husek, Paul <paul.husek@pfizer.com> wrote:
> Hello fellow Torquers,
> 
> I like how Torque allows you to retrieve a list of Torque objects with a
> single select.  That's great!  I'm looking for something similar for save()
> 
> I'm doing some profiling on my application and see that a lot of time is
> being used in the part of code where I save about 1000  Torque objects back
> to the database; they are all the same type.  Right now the code is
> essentially a for loop doing a save() on each object.   I'm wondering if
> there is a way to speed this up, by effectively passing an array of objects
> to be saved in a single method and allowing the Torque engine to only do a
> single prepare.
> 
> Instead of
> 
> for (int i=0;i<books.length;i++) {
> 
>    Book book=(Book)books[i];
> 
>    book.save();
> 
> }
> 
> The save method is taking up the vast majority of the time in this loop of
> course.
> 
> Maybe something like BookPeer.save(books);
> 
> Is there any method like this or any easy way to accomplish what I'm looking
> for?
> 
> Thanks much!
> 
>

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