Re: PL/SQL help please........
Date: 13 Oct 1994 19:37:12 GMT
Message-ID: <37k298$i6n_at_fred.uswnvg.com>
Nancy (ncg_at_ornl.gov) wrote:
: I'm working on a large software development project that involves the
: re-write of a very complex older system. We have recently decided to
: go with Oracle for our database strategy. Every member of the project
: team is an Oracle Newbie. We've all had some basic Oracle training and
: have just realized that several of us came away from the training with
: varying impressions of how much PL/SQL can do for us. We had intended
: to use PL/SQL to help with the more complex logic in the system. Would
: this cause a performance problem if we write all the software in PL/SQL
: and it's stored in the database ? Any guidance would be very much
: appreciated.
: Thanks,
: Nancy
: (ncg_at_ornl.gov)
Well, like everything else in this world, it depends. Keep this simple rule of thumb in mind. You will have to look at which method will work best for each case. There is no such thing as one rule fits all (I wish there is). Also, consider breaking up the complex logic into its component and see if there are other ways. Heck, you are re-writing the whole thing anyway. Remember, this is probably your only chance to re-design the stuff from ground up so do your best. Don't worry about how the old system looks like right now. If it is so great, why do anything at all!
Sorry I can't be more specific. To do that you will have to give me more info and I would have to charge you (I am a computer consulting specializing in ORACLE after all). Another advice, hire somebody who knows ORACLE very well. It is worth the money considering that bad design can cause endless headache for a very, very, very long time.
Kim Ng
(Just a low life contract programmer. Thus, my clients won't adopt my views.) Received on Thu Oct 13 1994 - 20:37:12 CET