Re: Master-Detail Strategy
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Sat, 21 May 2005 17:15:38 -0700
The appropriate approach really depends on the application architecture, how
many rows we're talking about, and how widely (or if) you expect to scale
the application.
In any application, this does not make much sense as you're transporting a
great deal of data to the client--data they might never need. I suggest
creating a filtered query that returns the selected master row. Once
selected, it's easy to execute a focused query to return activity related to
that row. With this approach, a detail fetch can be done in under a second
(if the query and indexes are done correctly).
My book(s) discuss this approach in detail...
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Bruce" <bvanderw-news5021@xxxxxxxxxxxxxx > wrote in message
news:dc4v81dngbtsemsb7hfjiivnbf5n0qs0ie@xxxxxxxxxx
>I have a master table that I would like to display on a form with a
> navigator, and I would like to display the detail records in a grid
> for each master record.
>
> Right now, I am getting all the records for both tables using
> DataAdapter.Fill and a "select * from <table>" select command. I am
> then setting up a DataRelation in code between the two tables.
>
> The problem I am having is that it is taking up to 30 seconds to fill
> the detail table because of it's size. Is there a way to dynamically
> retrieve and display (and edit) the detail records as each master
> record is displayed?
>
> I'm using the XtraGrid from Developer's Express for the detail records
> if it makes a difference.
>
> --Bruce
>
>
.
- References:
- Master-Detail Strategy
- From: Bruce
- Master-Detail Strategy
- Prev by Date: Master-Detail Strategy
- Next by Date: RE: Insert using C#
- Previous by thread: Master-Detail Strategy
- Index(es):
Relevant Pages
|
