Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database programming standards
Fernando
That is true if your company is still using a client-server architecture. Many new projects today use the Application Server model, so usually the AS is very close to the database server.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fernando
Sent: Thursday, June 03, 2004 11:03 AM
To: oracle-l_at_freelists.org
Subject: Re: Database programming standards
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
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 14:10:52 CDT
![]() |
![]() |