Oracle Efficiency Question.
Date: Sat, 6 Oct 2001 19:21:12 -0400
Message-ID: <9po3dp$5n3$1_at_bob.news.rcn.net>
Lets assume that I have a proC application that performs some oracle
operations. The execuable is located on the same server as the database so
there are no network transport issues. The question is will I get better
performance if I convert the oracle parts of the application to PL/SQL? The
application consists of SELECT, INSERT, DELETE and UPDATE and, of course,
consists of condition statements.
This is my feelings. I will experience better performance for the following
reasons:
First, am I on track and if so, will I save a significant amount of time
converting to PL/SQL or will the savings be negligable. Now I know that the
answer to this question is a function of the hardware and the amount of
transaction processing I am performing so I will state that I am running on
a 24 processor system and the application processes about 1 billion records
a day.
Oh yes, one other question. The application performs the same oracle