stored procedure cursor versus looping through using SQLDataClient in c#

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Roi Assa » stored procedure cursor versus looping...

stored procedure cursor versus looping through using SQLDataClient in c#

Rate Topic

Display Mode

Topic Options

Author

Message

kamaldeepb

Posted Thursday, July 17, 2008 8:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 15, 2009 6:28 AM
Points: 1, Visits: 8

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 »

Permissions