in reply to Re: Benchmarking Oracle - stored proc or insert
in thread Benchmarking Oracle - stored proc or insert

Ive got RaiseError on so the || die stuff would be superfluous anyway, Autocommit is on by default. I may try and turn it off and just do one commit at the end and see if it makes any difference.

NOTE: Chuffin 'eck turning off autocommit and doing one at the end makes the whole lot about 10x faster, i guess its just not committing every call...

  • Comment on Re: Re: Benchmarking Oracle - stored proc or insert