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)