Re: Database programming standards

  • From: Fernando <fernandoluis@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 3 Jun 2004 09:02:55 -0700

One person that DBAs can use as an "ally" is the network guy. With stored procedures, more of the processing is handled locally in the DB server(s). In large projects it might justify to create a simple prototype of both kinds of app (with and without PL/SQL) and test them using a network sniffer. Yes, performance diffs won't probably be seen in a small test, but you can measure the amount of data (# of packets) transmitted from the server to a "client" (might be an app server here). There are commercial tools and open source ones ( that you can use just to measure the data (and those SQL*Net stats can also be used).

On Jun 3, 2004, at 8:53 AM, Daniel Fink wrote:


I just had a conversation with a developer about the same kind of issue. After a long discussion, I recommended that they not use stored procedures and kept the data loading/validation in the app layer using java. In this case, they needed to get the app through the development process quickly, performance is not an option (at least at this point...I'm guessing this will change) and the team knows java, not pl/sql. He is well aware of the performance

Daniel Fink

---------------------------------------------------------------- Please see the official ORACLE-L FAQ: ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at FAQ is at -----------------------------------------------------------------

Other related posts: