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 <mgentr..asslight.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
>
This archive was generated by hypermail 2.0.0 : Mon Oct 18 2010 - 19:35:23 UTC