AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  plsql vs hibernate          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message yasaswi Guest Posted: Thu Jan 13, 2005 1:18 pm    Post subject: plsql vs hibernate 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 Back to top GreyBeard Guest Posted: Thu Jan 13, 2005 3:30 pm    Post subject: Re: plsql vs hibernate On Thu, 13 Jan 2005 05:18:36 -0800, yasaswi wrote: Quote: 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 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.