You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "John Huss (Jira)" <ji...@apache.org> on 2020/02/12 22:19:00 UTC

[jira] [Created] (CAY-2650) Support using generated primary keys along with batch inserts

John Huss created CAY-2650:
------------------------------

             Summary: Support using generated primary keys along with batch inserts
                 Key: CAY-2650
                 URL: https://issues.apache.org/jira/browse/CAY-2650
             Project: Cayenne
          Issue Type: Improvement
          Components: Core Library
    Affects Versions: 4.2.M2
            Reporter: John Huss
            Assignee: John Huss
             Fix For: 4.2.M2


Currently, using generated PKs explicitly prevents multiple inserts from using a batch-bind insert. This is unhelpful since switching to generated PKs could potentially cause a performance decrease for certain use cases because of the lack of batch insert functionality.

This is prohibited by the existing BatchAction:
{code:java}
if (runningAsBatch && !generatesKeys) {
	runAsBatch(connection, translator, observer);
} else {
	runAsIndividualQueries(connection, translator, observer, generatesKeys);
}{code}
Having done very brief performance testing against PostgreSQL, the performance difference turns out to be minimal for a realistic production scenario, but even so, this is a restriction worth removing I think.

I have a pull request coming for this.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)