CODEWITHSUNDEEP
asp.netsqlsql-server-2000connection-pooling
sansknwoledge
sansknwoledge

Reputation: 4259

connection pooling problem in asp.net

i am getting connection pooling error for my asp.net (3.5) application when deployed to the clients server. using a query (from googling) i found out one of my pages alone pumping around 56 connections to the server when it is opened, the page contains a nested gridview and it is having quite a large number of data around 2600 main grid data and n number of data in the child grid, the database in the client is sql server 2000 , what will be max connection pool setting in the web config , is there a way to overcome this problem.

Upvotes: 0

Views: 660

Answers (1)

VinayC
VinayC

Reputation: 49165

As @Mitch correcting pointed out, the better solution is not to adjust connection pooling setting up rather re-design your code so that it can work with single connection.

Current obvious issue is that every connection that you open should be closed immediately after your use them. But more than that you should consider below re-factoring:

  1. Try using single connection to get data for main grid and child grids. You might be firing multiple queries (resulting in multiple database trips).
  2. Next obvious step would be to fire multiple queries together or call to single sp that would fetch data for main grid and child grids together so that you reduce database trips to one.
  3. Next obvious step would to question if you need all this data together - for example, are you really planning to show 2600 rows at one time? If not then only fetch what you intend to show using database side paging.

Upvotes: 1

Related Questions