On 2/20/07, Rod Taylor <[EMAIL PROTECTED]> wrote:
Do 97% of transactions commit because Oracle has slow rollbacks and developers are working around that performance issue, or because they really commit?
Again, off-topic, but 97% of all transactions commit according to Jim Gray and his research... not anything related to Oracle.
I have watched several developers that would prefer to issue numerous selects to verify things like foreign keys in the application in order to avoid a rollback.
That's just bad development.
Anyway, I don't have experience with big Oracle applications but I'm not so sure that 97% of transactions would commit if rollbacks were cheaper.
Again, stats not related to Oracle, but databases in general. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
