Re: Stored procedures for OracleDb

"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