 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / New Users / January 2006TableAdapter Performance
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. 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.  SignatureGregory A. Beamer MVP; MCP: +I, SE, SD, DBA *************************** Think Outside the Box! *************************** > Hi, > [quoted text clipped - 10 lines] > > Thanks for reading. 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. >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 [quoted text clipped - 16 lines] >> >> Thanks for reading. Hi All, I have done a small benchmarking exercise to populate a strongly type Datatable having 3 columns with 10,000 records . I have followed four methods and perfrom 100 iterations to reac folowing results 1- DataTableAdapters fill method - takes Avg time of 281.01 ms 2- DataTableAdapters Getdatamethod - takes Avg time of 290 ms 3- Datatables Load method - takes 204.06 ms 4- Datatables Load method in conjnuction with BeginloadData/EndLoadDat takes 202.49 ms So This Resul shows that DataTables Load method along wit BeginLoadData and EndLoadData gives the best performace . If anyone ha any comments or queries Pls lemme know i can be reached a kapnitin@yahoo.co -- Niti 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 __________________________________________________________ > Hi, > [quoted text clipped - 10 lines] > > Thanks for reading. 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? > Are you filling a DataSet, or a DataTable with a lot of relations in it? > [quoted text clipped - 17 lines] >> >> Thanks for reading. 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 __________________________________________________________ > 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 [quoted text clipped - 23 lines] >>> >>> Thanks for reading. Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.