Performance question regarding the use of DataRelation in DataSet
From: Håkon Eide (he_at_webstep.no)
Date: 03/25/05
- Next message: mf_sina: "What is datacommand?"
- Previous message: Chris Zopers: "Performance with DataSet: suggestions for best practices?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Mar 2005 21:44:53 +0100
Hi,
I've got 2 DataGrids populated from 2 tables with a master/detail
relationship. Master table has about 13000 records, detail table about
100 000 records.
As I understand it, it would be possible to fill one single dataset with
data from both tables?
And then use a DataRelation to bind master data from grid 1 to detail
data in grid 2, so that when a user selects a row in grid 1, the
corresponding records are shown i grid 2?
If so, how would this reflect on performance? As far as I can tell, both
tables have to be fully loaded into the dataset for this to work? Or
does the .NET architecture do 'behind-the-scenes' querying and caching
and re-querying of the database?
DataRelation seems to be ideal for my case, but if that implies that the
users have to wait 2 minutes on application startup - then I'll have to
continue on my initial path, and do a new query on detail data everytime
a mousedown event fires on the master grid.
Regards,
-Haakon-
- Next message: mf_sina: "What is datacommand?"
- Previous message: Chris Zopers: "Performance with DataSet: suggestions for best practices?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
