• Post Reply Bookmark Topic Watch Topic
  • New Topic

Performance when mutiple resultsets are returned from a stored procedure ?

 
pritam dey
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have got a stored procedure where I want to put a number of SELECT queries. And each SELECT query must return one Resultset. Hence, finally, the stored procedure will have to return multiple resultsets. My database is SQL Server 7.0.
I want to know if this can de done using JDBC.
If so, can anyone tell me the performance related to this implementation ? Will if improve the performance or will it hamper it ??
Thanks,
Pritam
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!