Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6

On Tue, 10 Jul 2001 13:47:15 -0400, "uunet" <r_at_b.com> wrote:

Most likely your C program is executing in a client and using Net8 to connect to the server and send 1 row at a time. Use arrays and it will catch up in speed with PL/SQL.

Also, this is terribly slow:
>
> for (empno=1; empno<=num_rec; empno++)
> {
> EXEC SQL EXECUTE S USING :empno;
> EXEC SQL COMMIT;
> }

COMMIT after every 10 rows and you'll notice a very large performance improvement. Goes for PL/SQL too.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Jul 11 2001 - 08:00:21 CDT