Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of borut.bolcina@gmail.com
 designates 209.85.214.43 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=IwUuksm4aTVob6JatBF5FVLAK8s21bg7klMGBtkt30KwI4I6cDTD9GPp4MNGPtOV6I
         AwhYXko9Rmn6Hxp8GV5Z/la1C0bfdxx6v9WccJWNP5ScFDvL2gJB9ZO8pme2cX9QjBZt
         FzqJdd6f1lrH27p9afh5LVe8bfE09eS6yo3ew=
MIME-Version: 1.0
In-Reply-To: <AANLkTinGJiYP7r5zHf+Ed7pcov_8hSSA6RfDVHGhDU=e@mail.gmail.com>
References: <AANLkTim+bUamX3Xk8Ce3fvoh36egsC_ayAtGbPhTkr2g@mail.gmail.com>
	<AANLkTinGJiYP7r5zHf+Ed7pcov_8hSSA6RfDVHGhDU=e@mail.gmail.com>
Date: Mon, 18 Oct 2010 21:34:52 +0200
Message-ID: <AANLkTikWf7aT8TgicsWfNF8hMmxkvU_cemeNHwDDnche@mail.gmail.com>
Subject: Re: Writable FKs
From: =?UTF-8?Q?Borut_Bol=C4=8Dina?= <borut.bolcina@gmail.com>
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=001636c5a5222e15d20492e9456e

--001636c5a5222e15d20492e9456e
Content-Type: text/plain; charset=UTF-8

Hi,

what makes insert faster when doing it every 100 objects? In each case the
same number of inserts will be generated.

Can, beside using templates, Cayenne be configured to do something like:

INSERT INTO *tbl_name* (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);


That is one insert for 3 rows, which is more efficient (mysql).

-Borut

2010/10/18 Michael Gentry <mgentry@masslight.net>

> Hi Borut,
>
> In addition to what Andrus said about caching Towns, Streets, and
> PostOffices, you should also try to do your commits in larger
> groupings.  One commit at a time will be slower than you want for
> something like this.  Try grouping 100 or so at a time before you
> commit.
>
> mrg
>

--001636c5a5222e15d20492e9456e--