developers

    Forum Stats

  • 3,873,653 Users
  • 2,266,622 Discussions
  • 7,911,597 Comments

Discussions

Query Regarding Connection string

User_42Z26
User_42Z26 Member Posts: 12 Green Ribbon

Hi,

I have defined connection string in my C# application, So database oracle side is lot of burden, since this client application is using by lot of customer,

so I have a query, How much "Connection Lifetime" should be defined in my connection string.

so our application also work effectively.

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,153 Employee

    Nowadays, you shouldn't need to use Connection Lifetime anymore. There are better failover alternatives, such as Fast Connection Failover.

    In terms of improving DB server performance, you should use connection pooling on the client side. Some other options include using shared server or Database Resident Connection Pooling. These options do a better job sharing connection resources on the DB side.

developers