Dataset ar DataReader?

#1

I am writing a remoting application and my server object passes result sets
from a SQL Server database to the clients. What data object should I use if
I want to maximize performance: Dataset, DataReader, other?

#2

"Wannano" <marc.biotteau (AT) sympatico (DOT) ca> wrote in
news:OeqGwpgyHHA.4276 (AT) TK2MSFTNGP05 (DOT) phx.gbl:

Quote:

I am writing a remoting application and my server object passes result
sets from a SQL Server database to the clients. What data object
should I use if I want to maximize performance: Dataset, DataReader,
other?

It really depends on the circumstance, but in general, DataReaders are
faster and more efficent than Datasets.

#3

Hello Wannano!

Quote:

What data
object should I use if I want to maximize performance: Dataset,
DataReader, other?

A Dataset is filled by a DataReader. So when you just read simple rows, a
DataReader will be allways faster than a DataSet.

But: A DataSet is much more than a collection of rows. When you use the rich
DataSet features it may be better to use the DataSet than implementing this
behavior on you own.

GP

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dataset ar DataReader?

Dotnet Framework (Remoting) microsoft.public.dotnet.framework.remoting

Dataset ar DataReader? - 07-19-2007 , 09:40 AM

Re: Dataset ar DataReader? - 07-19-2007 , 01:44 PM

Re: Dataset ar DataReader? - 07-20-2007 , 02:41 AM