TableAdapter Performance

[Programatix]

Hi,

Have anyone ever benchmark the TableAdapter performance compared to
DataTable's Load method? I found out that the DataTable's Load method is
about 10x faster than TableAdapter's Fill method.

I used the same SELECT query and DataSet (predefined), for both test.

For the DataTable's Load method, we first need to create a DataReader.

Anyone know why? Or is there any other configuration needed to make
TableAdapter faster?

Thanks for reading.

 

[Guest]

I would have to see what you are attempting to do to better understand. One
of my former coworkers did some tests with the TableAdapter that absolutely
smoked. It was compared to filling DataSets, however, so the tests may be
invalid in your world.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Programatix]

The DataTable's Load method also fill the dataset. But it reads from a
DataReader that we need to supply. Take a look at the Load method for
DataTable.

 

[Sahil Malik [MVP C#]]

Are you filling a DataSet, or a DataTable with a lot of relations in it?

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[Programatix]

Hmmm.. There are 4 DataTables in the DataSet. Each is linked with each other
in a seriel form, meaning that table 1 is related to table 2, table 2 is
related to table 3 and so on.

Why?

 

[Sahil Malik [MVP C#]]

Okay try this -

On the 4 tables, call "BeginLoadData" before you start filling, and
"EndLoadData" after the data has been filled. See if that helps.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________