http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10454 --- Comment #14 from Galen Charlton <gmcharlt@gmail.com> --- As a point of information, I also tried using DBIx::Sequence. Pros of using DBIx::Sequence: - It works, in the sense that using a bunch of concurrent processes to fetch sequence values will get unique IDs. - It appears to be DBMS-agnostic Cons: - Under high simultaneous load, it is *significantly* slower to retrieve sequence values because of the way it implements spin-locking. - It doesn't expose a way to explicitly initialize a sequence to a given value. - The semantics of its Currval method are wrong -- ideally Currval() should stay stable within a session, but DBIx::Sequence->Currval() can change if another process fetches a value from the sequence. On balance, I prefer a roll-our-own because of the first two "cons". -- You are receiving this mail because: You are watching all bug changes.