All Tables in single dataset vs multiple datasets.

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I wanted to know if it is better to use one dataset for my
entire application and include all tables in the dataset
or to use multiple datasets and only include related
tables in each dataset? Also is there some limit or rule
as to how many tables can safely/efficiently be included
in a single dataset?

Thanks
Mike
 
Hi Mike,

There is no rule.
I normally put tables related to a business operation in the same dataset so
I have isolated dataset for the operation.
 
It really depends on the app and the nature of the data. For example, a
disconnected app would do better with all of the data downloaded in one
DataSet. A web app, or most other connected apps, work better with focused
data in individual Datasets (containing the data you are working with on a
single form).

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

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top