Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Compare sql and dynamic sql

Re: Compare sql and dynamic sql

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Fri, 01 Oct 1999 04:17:53 GMT
Message-ID: <RBWI3.615$9j6.10515@news.rdc1.pa.home.com>

Barbara Kennedy <barbken_at_teleport.com> wrote in message news:OiTI3.861$k57.32343_at_news1.teleport.com...
> If you change to using host variables in the insert statement then it
could
> be faster since less CPU processing would occur on the server. (after the
> first statement). The I/O would be about the same in either case; but
less
> CPU usage would allow things to scale better if that is a concern.
> insert into foo_1 values (:firstCol,:secondCol);

Point well made, and infact that method would be best suited to be done within a procedure, or pl/sql block. Making the point that a stored procedure is actually faster than native.

>
> Jim
>
> Jay <mighty_dragon_at_hotmail.com> wrote in message
> news:37F37FD5.1D9B1096_at_hotmail.com...
> > For a large number of sql statements w/c contain a pattern, for example:
> >
> > insert into foo_1 values (1, one);
> > insert into foo_2 values (2, two);
> > insert into foo_3 values (3, three);
> > ...
> > insert into foo_n values (n, n);
> >
> > Someone had claimed that the above execution is faster than any means
> > like using stored procedures with pl/sql OR dynamic sql OR native
> > dynamic sql.
> >
> > Can anyone explain any reason why using stored procedures would be
> > slower.
> >
> > Is there any overhead using dynamic sql over straight sql???
> >
> > In any case, can anyone refer me to a document that will explain in some
> > details how dynamic sql execute internally.
> >
> >
> >
> > Thanks in advance for any help.
> >
>
>
Received on Thu Sep 30 1999 - 23:17:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US