C# database connection delay

Question

I have an app, it's done and working, but the users report a small problem with it, and quite frankly i susspected it could be a problem. As the title says the app is written in c# (.net 3.5) and it's using SQL DB. The "problem" is - when the app is first started, it takes about a half a minute to conenct to database.

Could this be somehow reduced?

Thank you for your time!

EDIT1: the DB is local.. sql server and .net framework are installed at the same time as the app

EDIT2: when the app is stared it all works fine, and when users open the winform where some DB work needs to be done, the first time it's started they have to wait about half a minute, after that it works fine..

Is that perhaps doing an auto-start on the underlying database? — Marc Gravell
– Marc Gravell, Commented Feb 16, 2011 at 9:28
Ok, and has this 'first execution' always taken place immediately after an install? — Grant Thomas
– Grant Thomas, Commented Feb 16, 2011 at 9:45
not necessarily.. there's alway the delay when the program is first started after turning the computer on — Andrej
– Andrej, Commented Feb 16, 2011 at 10:03
If you start the program, run it once, close it and start it again, do you get another delay or does it work instantly? — David Mårtensson
– David Mårtensson, Commented Feb 16, 2011 at 10:52

Grant Thomas · Accepted Answer · 2011-02-16 12:34:03Z

4

From questions I asked in comments and their respective answers, the conclusion I offer is this:

It seems to me that the server agent service may be set with a startup mode of Manual. This means the service will only start as and when required by an application:

Manual starts a service as required or when called from an application (according to definition, but only some of the time in practice, depending on the service)

To mitigate this you could create a custom install action which would, as part of your product installation, set this startup mode to Automatic - this would cause the service to start when Windows starts.

edited Feb 16, 2011 at 12:34

answered Feb 16, 2011 at 12:05

Grant Thomas

45.1k10 gold badges88 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andrej Over a year ago

insteresting, now off to find a way to enable this during silent install and i'm good to go... tnx!

Andrej Over a year ago

there it is.. /AGTSVCSTARTUPTYPE needs to be set on "Automatic" .. tnx for the anwser once more!

Grant Thomas Over a year ago

Any time. Glad you're sorted. :)

Collectives™ on Stack Overflow

C# database connection delay

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related