Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

stored procedure cursor versus looping through using SQLDataClient in c# Expand / Collapse
Author
Message
Posted Thursday, July 17, 2008 8:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:23 PM
Points: 1, Visits: 9
I have 300,000 records in a data file that need to be validated and processed. I am using DTS package to upload the file to a database table. Each of the loaded records need to be validated against the database.

Which will be more performance efficient, using a cursor in stored procedure or, creating a .Net program to loop through all the rows in the table and validate all the records against the database.
Post #536022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse