I am refining some design after testing other parts of it, this is all going well but we need to now improve the data reading part, doing a bulk "SELECT *" was fine for testing, but is no good for massive tables.
We have a managaed stored proc, coded in C#, we use this to copy a table over a network to a special server of our own, this is an ocassional one-off operation.
I want to recode this stored proc, so that we enumerate a row at a time (or 'n' rows, e.g. 10, 20 etc) and send these over the network.
Doing this iteratively is the goal, I read a little recently about Server Side Cursors which seem ideal, especially for tables with 500,000 rows +
Does ADO.NET provide any managed classes for doing this?
We use .Net 3.5, Visual Studio 2008 and SQL Server 2008 R2.
Performance is key, you can assume that the database is not being updated when this operation is run.
View Complete Post