Performance when mutiple resultsets are returned from a stored procedure ?
posted 14 years ago
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