http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10454
--- Comment #14 from Galen Charlton <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
