stored procedure « Performance « JPA Q&A





1. hibernate v/s stored procedure or functions performance    stackoverflow.com

I am analyzing the options for database layer in my application. I found hibernate a very popular choice however few friends told that better to use stored procedures / function rather ...

2. Performance problem - using Ref Cursor in stored procedure call from Hibernate    coderanch.com

I am using many stored procedures in my application. And We are calling them using normal callable statements. Issue is the stored procedure takes very little time to execute.. hardly couple of seconds. But it just hangs as soon as we do "while(rs.next)". I got to know ref cursor only start executing when first time "rs.next " is called. But the ...