Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedures for OracleDb

Re: Stored procedures for OracleDb

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 1 Feb 2006 09:31:35 -0500
Message-ID: <uaWdnfvpwcTXW33enZ2dnUVZ_tSdnZ2d@comcast.com>

"sb" <sonali.bhavsar_at_gmail.com> wrote in message news:1138795602.020311.102980_at_g44g2000cwa.googlegroups.com...
> Hi All,
>
> I am in a dilemma where I wastoldby other developers in my team that
> complex stored procedures are not used for accessing oracledb where the
> tables return millions of rows of data. Is this true? The smarts after
> retrieving the data is done in business objexts using Pro C.
> This OracleDb is 10g.
> Please advise.
>

not true -- perhaps depending on what you're doing, but generally not true

there are efficient ways (and ineffiient ways) of handling data in stored procedures -- and in other languages

consider though, the benefits of processing the data at the database (which is designed to handle big chunks of data) before transporting it to another tier (which has to have all processing logic built from the ground up

know and exploit the database functionality -- it's not just a big file server

++ mcs Received on Wed Feb 01 2006 - 08:31:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US