Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 63480 invoked from network); 20 May 2009 11:51:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 20 May 2009 11:51:20 -0000 Received: (qmail 90140 invoked by uid 500); 20 May 2009 11:51:33 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 90102 invoked by uid 500); 20 May 2009 11:51:33 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 90092 invoked by uid 99); 20 May 2009 11:51:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 May 2009 11:51:33 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of chubrilo@gmail.com designates 209.85.219.164 as permitted sender) Received: from [209.85.219.164] (HELO mail-ew0-f164.google.com) (209.85.219.164) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 May 2009 11:51:21 +0000 Received: by ewy8 with SMTP id 8so523710ewy.38 for ; Wed, 20 May 2009 04:51:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=rvBtStzcfsALa4TTUhi3je+xeHgC+gts8plGz0sNZZg=; b=mJ2nqFnJpjZVNO7IOAkFyONh+7SzlaGkMCHtvRVK62MuklfH7j6bKu4mZEXkIMS4Ji 9jtHKsDizD3NHqNp7zOLmoSE72DtLpS8eXQNUYx03x996N5HQRdt/sHwhVS+zj4yd/iF pXDiIxSopajWEP/qKHrxXFyzkaPFWDsqHSCjY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=wcM3yXet9YVnxfe7qX1R3VWuI00Mh7qxuHymXOSFc/Zd2szK4W+rJJ1uzQg3y4DFaP 2YTdfY1G+QXZzpqL46imm7lTCPECr4okZM83OWOdHfORh8khYFAffEfJIW3XFR0nmNit EYwr4x+WDg6iTQWdiyEVUSf+yidKceG9JHNDA= MIME-Version: 1.0 Sender: chubrilo@gmail.com Received: by 10.210.87.11 with SMTP id k11mr1566419ebb.91.1242820261473; Wed, 20 May 2009 04:51:01 -0700 (PDT) In-Reply-To: <23633548.post@talk.nabble.com> References: <23633548.post@talk.nabble.com> Date: Wed, 20 May 2009 13:51:01 +0200 X-Google-Sender-Auth: da78068f04c779a5 Message-ID: <36e91d9d0905200451r43ffe2bak9558ee4d4033fe90@mail.gmail.com> Subject: Re: Batch processing From: Dejan Bosanac To: users@activemq.apache.org Content-Type: multipart/alternative; boundary=0015174c1632346f9d046a56a489 X-Virus-Checked: Checked by ClamAV on apache.org --0015174c1632346f9d046a56a489 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, you can use JMS transactions and commit them after you commit your DB. Cheers -- Dejan Bosanac Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Wed, May 20, 2009 at 1:22 PM, milan tomic wrote: > > Howdy, > > I have this case: > > For each message that comes, I have to insert an record into MY_LOG table > and to make commit. Commits slows my DB, so I have decided to use MQ. The > question is: does MQ supports batch processing of messages? Can I say: give > me 50 messages from the queue at once, so I would make 50 INSERTs into DB > and ony 1 commit? Which is the best way to do this? > > Thank you in advance, > Milan > -- > View this message in context: > http://www.nabble.com/Batch-processing-tp23633548p23633548.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > > --0015174c1632346f9d046a56a489--