R – Performance concerns between DataSet and stored procedure

datasetperformancestored-procedures

I have to develop one program that consists data manipulation (retrieve data, update data and new insert data) to multiple tables. Which will be suitable approach and faster in performance using DataSet object and stored procedure with CURSOR object? Please point me out. Thanks you all!

Best Answer

Data manipulation is typically faster when done in the DB in the stored procedure.

Unless there is a reason you have to do the manipulation within the application, do it on the DB itself.

Related Solutions

Sql-server – Select columns from result set of stored procedure

Can you split up the query? Insert the stored proc results into a table variable or a temp table. Then, select the 2 columns from the table variable.

Declare @tablevar table(col1 col1Type,..
insert into @tablevar(col1,..) exec MyStoredProc 'param1', 'param2'

SELECT col1, col2 FROM @tablevar

Sql – Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure

Simple answer: No.

Best Answer

Related Solutions

Sql-server – Select columns from result set of stored procedure

Sql – Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure

Related Topic