Fastest way to load data

[Sehboo]

I have to call a stored procedure which returns about 1000 rows with
about 5 fields (most of them are int).

What is the fastest way to load this data?

if I just do DataTable.Load, then is it fast? or should I do something
else?

Thanks

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

You can either get a DataReader or a DataSet. DataReader keeps the open
connection and is "Firehose" style one way access through your data. If you
need to be able to work with the data after closing the connection, then you
need to get a DataSet. DataSet has more overhead, but with only 1000 rows and
5 columns, you would never be able to notice the difference. Check out the
QUICKSTARTS samples for example code.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Sehboo" wrote:

I have to call a stored procedure which returns about 1000 rows with
about 5 fields (most of them are int).

What is the fastest way to load this data?

if I just do DataTable.Load, then is it fast? or should I do something
else?

Thanks

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

P.S. DataTable Load method uses a supplied DataReader "under the hood".
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Sehboo" wrote:

I have to call a stored procedure which returns about 1000 rows with
about 5 fields (most of them are int).

What is the fastest way to load this data?

if I just do DataTable.Load, then is it fast? or should I do something
else?

Thanks

[susiedba]

I would just use BULK INSERT

ADO.net doesn't have _HALF_ of the performance / functionality as ADO
Classic

On Feb 12, 1:22 pm, "Sehboo" <[e-mail]:

I have to call a stored procedure which returns about 1000 rows with
about 5 fields (most of them are int).

What is the fastest way to load this data?

if I just do DataTable.Load, then is it fast? or should I do something
else?

Thanks