Re: Database programming standards

From: Fernando <fernandoluis_at_mac.com>
Date: Thu, 3 Jun 2004 09:02:55 -0700
Message-Id: <79778B9D-B577-11D8-8C74-000A95A6AB02@mac.com>

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 (www.ethereal.com) 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
> problems.
>
> Cynically,
> Daniel Fink
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 03 2004 - 10:59:53 CDT