You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Дыбин Дмитрий <dd...@diasoft.ru> on 2012/09/05 07:34:56 UTC

a question about multiple inserts performance

Hi!
How do you think, what'll work faster for inserting multiple rows with one query but different data:
 - querychain with a query for each row

-          Insertbatchquery witch a list of data

Thanks!

Dybin Dmitriy

Re: a question about multiple inserts performance

Posted by Michael Gentry <mg...@masslight.net>.

Hi there,

How many objects are you talking about?  InsertBatchQuery works with
DataRows, also, not DataObjects (normal Cayenne objects).

mrg


On Wed, Sep 5, 2012 at 1:34 AM, Дыбин Дмитрий <dd...@diasoft.ru> wrote:
> Hi!
> How do you think, what'll work faster for inserting multiple rows with one query but different data:
>  - querychain with a query for each row
>
> -          Insertbatchquery witch a list of data
>
> Thanks!
>
> Dybin Dmitriy