Designing a Dataset

[CypherDrive]

Dear Experts,

Good Afternoon, May you please help us with this issue. We're using VB.NEt
2005.

Which dataset is better in terms of Design, Flexibility and Speed in
Processing. Will you please rank them based on the criteria I gave you and
Give us

A. System that consist only 1 Dataset and containing all Datatables with
relationship designed from an SQL Database.
* All Datatables were previously Filled

B. System that consist only 1 Dataset and containing all Datatables with
relationship designed from an SQL Database.
* Selected or Needed Datatables were previously Filled and Called by

C. System that consist of 1 Dataset for every Form and Containing Only
Needed and Selected Datatables with relationship specifically Configured and
accessed by Specific Forms that needs the data
* Selected Datatables were previously Filled


D. System that consist of Many Dataset for very Form and Containing Only
Needed and Selected Datatables with relationship specifically Configured and
accessed by Specific Forms that needs the data
* Selected Datatables were previously Filled


Thanks in advance for your reply..

Regards,

Alvin

 

[Jialiang Ge [MSFT]]

Hello Alvin,

Each solution (A~D) has its own pros and cons. The choice depends on the
application context. For example:

The solution A has the strength that the DataSet only needs to be filled
once. However, if the DB has a very large pool of data or if the request of
data is very rare, the solution A will waste a large number of server
resources and may causes a lot of performance issues.

I generally prefer to do it in this way:
1. Fill only when necessary
2. Design DataSet in logic view (For example: if Table1 and Table2
constitute a business object, I will compose them to a DataSet)

Hope it helps

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.