[
https://issues.apache.org/jira/browse/CAY-2650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev updated CAY-2650:
---------------------------------
Affects Version/s: (was: 4.2.M2)
> 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
> Reporter: John Huss
> Assignee: John Huss
> Priority: Minor
> Fix For: 4.2.M1
>
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> 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)
