Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: plsql vs hibernate
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
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