cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Borut BolĨina <borut.bolc...@gmail.com>
Subject Re: Writable FKs
Date Mon, 18 Oct 2010 19:34:52 GMT
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
>

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