What can I do about Slow application!

  • Thread starter Thread starter Lars Netzel
  • Start date Start date
L

Lars Netzel

I have an application that uses a lot of OleDbDataAdapters and of course
need a connection for each adapter..

If I run against the Accessdatabase locally it's fine but if I put the
databasefile on the network, it's a lot slower... (which I guess is logical)
but the customer is not happy about this and I guess I'm suppossed to solve
this.. so Please is there anything I can do to speed things up a little?
Some special ways the connection string can be written in? mayeb I have some
properties that are unnessessary and make things slower and things like
that?

I guess it's possible to have everything goind against ONE adapter.. and use
one big mutha' Dataset for all, to be able to have a connection OPEN all the
time.. but I'm not sure how much that woudl help and I honstly don't have
time for that!

regards
/Lars Netzel
 
Hi,

Two sugestions. Fill the dataset in a thread so it loads the
data in the background. Other option is to create a web service to pass
the data to the application.

Ken
---------------
I have an application that uses a lot of OleDbDataAdapters and of course
need a connection for each adapter..

If I run against the Accessdatabase locally it's fine but if I put the
databasefile on the network, it's a lot slower... (which I guess is logical)
but the customer is not happy about this and I guess I'm suppossed to solve
this.. so Please is there anything I can do to speed things up a little?
Some special ways the connection string can be written in? mayeb I have some
properties that are unnessessary and make things slower and things like
that?

I guess it's possible to have everything goind against ONE adapter.. and use
one big mutha' Dataset for all, to be able to have a connection OPEN all the
time.. but I'm not sure how much that woudl help and I honstly don't have
time for that!

regards
/Lars Netzel
 
Okay! Thanx, a two questions though..

Web Service? This is a stand alone Windows Forms application that works with
an Access 2000 db file... how can I use a webservice in a good way here?

Thread, how do you mean? Never worked with threads and don't really know
what it is!

/Lars
 
Back
Top