This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

callablestatement.getobject takes long time

 
Chinni Bujji
Ranch Hand
Posts: 60
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have stored procedure and I am trying to call it using a callable statement
but the number of rows in the table are huge and it will constantly increase
right now the number of rows are 22894772

and my stored procedure at a time should get me 25 records
my question is when we callablestatement.getobject() will it get total records in the table thats why it is taking too long approximately 2 minutes
or will it get 25 records into the resultset

thanks in advance
 
Rob Spoor
Sheriff
Pie
Posts: 20381
46
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It depends on your database driver so you'll have to try it. Why not pass the start/end index to your stored procedure and let it only return the 25 rows you need?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic