In a message dated 23/10/2006 03:02:54 GMT Standard Time,
srussell (AT) lotmate (DOT) com writes:
Bring back a table at a time instead of a huge DS. Use those tables to
repopulate your local DS.
Stephen Russell
DBA / .Net Developer
Sorry I forgot to mention that I have even tried to load the main table to
the dataset to a datagrid, and everytime a row is slected on that dataGrid I
place another call to the database to fetch all the other child tables that
match the selected row ID. but even that takes abotu 30seconds at least to bring
the data back, and imagine everytime you click on a row in the data grid, it
takes 30seconds or a minute to resume the filtering! but not sure what you
were suggesting in your idea so perhaps your expanstion can be valuable
herethanks Steve.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*To visit your group on the web, go to:
<*Your email settings:
Individual Email | Traditional
<*To change settings online go to:
(Yahoo! ID required)
<*To change settings via email:
mailto:CSharpNET-digest (AT) yahoogroups (DOT) com
mailto:CSharpNET-fullfeatured (AT) yahoogroups (DOT) com
<*To unsubscribe from this group, send an email to:
CSharpNET-unsubscribe (AT) yahoogroups (DOT) com
<*Your use of Yahoo! Groups is subject to:

Sorry I forgot to mention that I have even tried to load the main table to
the dataset to a datagrid, and everytime a row is slected on that dataGrid
I
place another call to the database to fetch all the other child tables
that
match the selected row ID. but even that takes abotu 30seconds at least to
bring
the data back, and imagine everytime you click on a row in the data grid,
it
takes 30seconds or a minute to resume the filtering! but not sure what
you
were suggesting in your idea so perhaps your expanstion can be valuable
herethanks Steve.

1) how many rows are coming back in 30 sec.?
2) If only a few, your query for that data needs to be refactored.
3) if a lot of rows, WHY?
4) What makes a little into a lot? 50
5) Do you have an index on a join for your data?

Yahoo! Groups Links

<*To visit your group on the web, go to:

<*Your email settings:
Individual Email | Traditional

<*To change settings online go to:

(Yahoo! ID required)

<*To change settings via email:
mailto:CSharpNET-digest (AT) yahoogroups (DOT) com
mailto:CSharpNET-fullfeatured (AT) yahoogroups (DOT) com

<*To unsubscribe from this group, send an email to:
CSharpNET-unsubscribe (AT) yahoogroups (DOT) com

<*Your use of Yahoo! Groups is subject to: