Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Pl/SQL coding efficiency

0 views
Skip to first unread message

Tony Damon

unread,
Jan 25, 1996, 3:00:00 AM1/25/96
to

From a performance/"size of compiled code" standpoint, which would
be more efficient:

1) code lots of "insert into xyz values('abc');" statements.

or

2) code an insert procedure "isrt(varchar2)" that performs the
actual insert, and then call that procedure many times?


Does the overhead of calling a procedure to do an insert
outweigh the multiple "insert into" statements coded? Or,
upon compilation does oracle convert these "insert into"
statements into a call itself?

Thanks,
Tony Damon


0 new messages