1. hibernate v/s stored procedure or functions performance stackoverflow.comI 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.comI 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 ... |