| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about parse
A copy of this was sent to "Antonio Pascual" <apa_at_jerez.micro.lucent.com>
(if that email address didn't require changing)
On Thu, 10 Jun 1999 13:29:54 +0200, you wrote:
>Hi all.
>
>I have a loop that make about 1000 insertions in a table.
>The program use the OCI.
>Every time i have to make oopen, oparse y oexec.
>
>I want to increase the performance of the program.
>I think that i could put the oopen out of the loop.
>But i don't know what to do with oparse. Why i have to parse
>each sentence if all are equal, and are good?.
>
>I think thah i could use stored procedures.
>
>Could you help me?
>
move the open and parse outside of the loop and only do the exec inside. Use ARRAY processing if you want this to go faster. That will give you the biggest bang for the buck.
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--
 |
 |