Performance question

  • Thread starter Thread starter Kevin H
  • Start date Start date
K

Kevin H

Is there a performance hit for using 1 dataset with many
data tables versus many datasets with one table each? I
have coded an app which adds a data table for each data
view I touch. A coworker wrote his code to create a new
dataset for each view he touches, with one table per
dataset. My app hits about 75 views. Is there an optimal
balance, or does it matter?

TIA

Kevin
 
Hi Kevin,

The only performance hit I see is that you'll have to create n-dataset
instances while coworker creates only one.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Design Question 3
DataAdapter in vs2008 7
SQL JOIN between DataTables in a DataSet 4
Organize Data in a DataSet 1
Add column using Dataset Designer => hosed project 2
update database from dataset 2
Improving DataSet.Merge() performance 8
transform xml messages into SQL Sever 1

Back
Top