On Aug 10, 2011, at 7:23 PM, Joseph Senecal wrote: > Is there any reason not to use something like this: > SELECT tablename.nextval, tablename.nextval, tablename.nextval ... FROM DUAL > to get multiple primary keys from a sequence?
Possibly, but normally Cayenne would get keys in blocks of 20 or higher, which is pretty efficient, even if it may cause some ID gaps. So there was no motivation for other optimizations. Andrus
