CODEWITHSUNDEEP
c#asp.netvb.netado.net
user240141
user240141

Reputation:

Optimal Database connection string for high traffic connections?

I just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.

Upvotes: 0

Views: 341

Answers (3)

Mark Sowul
Mark Sowul

Reputation: 10610

In any event make sure you reuse the same connection string throughout the app so as to enable connection pooling.

Upvotes: 1

Steve Wellens
Steve Wellens

Reputation: 20638

If a lot of the data is read-only and repeatable, caching can be your best friend.

Upvotes: 0

GoldBishop
GoldBishop

Reputation: 2861

you definitely dont want to persist the connection. probably want to move towards a client dataset loading so the users carry the load of data but then again you may want to review your Database farm configuration with virtualizing.

if you are talking about well over 1 million hits, creating a DB farm with a load balancer would be your best configuration. Another path is to seperate your DB request from the application and through a Web Service type interface to manage the connections.

if less than 1 Million hits, then its best to manage the resources through the application but better have some good dba's to manage the pipes and throttle when necessary.

Upvotes: 0

Related Questions