Ron Johnson wrote:
>> Moving all the application-bound inserts into stored procedures didn't
>> achieve nearly the performance enhancement I'd assumed I'd get, which I
>> figured was due to the overhead of the procs themselves.
>
> Would that be because the original app was written in a compiled
> language, but the SPs in an interpreted language?
No, because the application language was Perl5 for both. I think it was
just the overhead of 2 million inserts via procs versus 2 million inline
inserts (without the proc overhead).