Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6
From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 11 Jul 2001 13:00:21 GMT
Message-ID: <3b4c4b30.816444_at_news-server>
Date: Wed, 11 Jul 2001 13:00:21 GMT
Message-ID: <3b4c4b30.816444_at_news-server>
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 - 15:00:21 CEST