By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

What can I do about Slow application!

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
---------------
"Lars Netzel" <[stop_spam]@host.topdomain> wrote in message
news:e6*************@TK2MSFTNGP09.phx.gbl...
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

Nov 20 '05 #2

P: n/a
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
"Ken Tucker [MVP]" <vb***@bellsouth.net> skrev i meddelandet
news:%2****************@TK2MSFTNGP11.phx.gbl...
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
---------------
"Lars Netzel" <[stop_spam]@host.topdomain> wrote in message
news:e6*************@TK2MSFTNGP09.phx.gbl...
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

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.