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).
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
