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)
