Too many DataAdapters on a Form???

  • Thread starter Thread starter Anton Kerschbaummayr
  • Start date Start date
A

Anton Kerschbaummayr

Hi there!

We are writing an application with a form wich has a master table and 7
detail tables on it.
Each table has its own DataAdapter, but it dures 0,3 seconds to load one of
them, in sum it
dures 2,1 seconds.
So, each time we navigate to the next datarow it dures 2,1 seconds!!

What are we doing wrong?

Thanks,
Tony
 
How many records are you talking about on the largest of the tables?
Depending on size 3 seconds can be pretty common. I'm not sure about the
navigation, it depends on how you are 'navigating' exactly.

There are a lot of possible variables, and the most likely culprit is large
tables. If you could post a code snippet, I can give you some more precise
suggestions.

HTH,

Bill
 
Hi Bill!

Thanks for your quick answer!
I think the problem is not the amount of data we query, because we only
query
only query one customer with the where clause, i.e. "WHERE CustomerID = 3".

Now we've tried to put all SELECT-Commands for each table in one DataAdapter
seperated by
a semikolon, and then the query works fine and dures only about a half
second.
For the UPDATE, INSERT and DELETE Command, each table has its own
DataAdapter, and
that seems to work fine, but is this really the right way to solve this
problem?

mfg,
Tony.
 
Back
Top