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

Home -> Community -> Usenet -> c.d.o.server -> Re: plsql vs hibernate

Re: plsql vs hibernate

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Thu, 13 Jan 2005 15:30:22 GMT
Message-Id: <pan.2005.01.13.15.29.13.284804@gmail.com>


On Thu, 13 Jan 2005 05:18:36 -0800, yasaswi wrote:

> I have Oracle 10g database. Please comment on performance issues
> related to PL/SQL vs Hibernate. I have a complex data schema that would
> need lot of complex joins. I am leaning towards PL/SQL procedures and
> JDBC combination, because speed is more important than scalability
> across multiple database platforms. Is my thinking right given the
> complexity in database schema?
> Thanks,
> Yasaswi

What do you mean by 'complex joins'? Are you implying that the application will join the data, rather than using the SQL language? If so, you really need to rethink your logic.

To answer your question, the general rule is

  1. Do it in SQL
  2. Try again - do it in SQL
  3. No, I mean really - do it in SQL
  4. Do it in PL/SQL
  5. Do it in the application

You might find books like 'Mastering Oracle SQL' http://www.oreilly.com/catalog/0596006322/ helpful to accompplish 1, 2 or 3.

Look at Thomas Kyte's "Effective Oracle By Design" for tricks, methods, reasons and proof for PL/SQL before Hibernate.

lol/FGB Received on Thu Jan 13 2005 - 09:30:22 CST

Original text of this message

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