Connection pooling

Discussion in 'ASP .Net' started by =?Utf-8?B?VmFtJHk=?=, Nov 24, 2004.

  1. Hi all

    Iam working on a web based project using asp.net and sql server 2000. I have
    written stored procedures whenever i want to interact with data base and in
    connection string i had put min pool size=1;max pool size=500.

    And in each page load one stored procedure will get executed as iam
    capturing the url and inserting into data base. so for each insert one
    process is getting created in SQL Server and the process is going to sleep
    mode and its staying back till i close the browser. and rest of stored
    procedure process is getting created and killing once the work is done. once
    i close the browser all process which are there are getting killed. But why
    the status is going to sleep mode all the time is my question ever though iam
    closing the connection and disposing.

    Thanks is advance,
    Vamsi
     
    =?Utf-8?B?VmFtJHk=?=, Nov 24, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?VmFtJHk=?=

    Patrice Guest

    First, my personal preference is to leave default values unless you have a
    very good reason do to so (IMO 500 is really really high).

    With pooling, the connection is not really closed. Instead it is kept so
    that it is already available for someone else...

    Patrice


    --

    "Vam$y" <> a écrit dans le message de
    news:...
    > Hi all
    >
    > Iam working on a web based project using asp.net and sql server 2000. I

    have
    > written stored procedures whenever i want to interact with data base and

    in
    > connection string i had put min pool size=1;max pool size=500.
    >
    > And in each page load one stored procedure will get executed as iam
    > capturing the url and inserting into data base. so for each insert one
    > process is getting created in SQL Server and the process is going to sleep
    > mode and its staying back till i close the browser. and rest of stored
    > procedure process is getting created and killing once the work is done.

    once
    > i close the browser all process which are there are getting killed. But

    why
    > the status is going to sleep mode all the time is my question ever though

    iam
    > closing the connection and disposing.
    >
    > Thanks is advance,
    > Vamsi
     
    Patrice, Nov 24, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Trevor Hartman

    connection pooling

    Trevor Hartman, Jul 28, 2003, in forum: ASP .Net
    Replies:
    2
    Views:
    579
    Mark Heimonen
    Jul 28, 2003
  2. Chris Szabo

    connection pooling error

    Chris Szabo, Aug 19, 2003, in forum: ASP .Net
    Replies:
    6
    Views:
    1,913
    Chris Szabo
    Aug 19, 2003
  3. William \(Bill\) Vaughn

    Re: SqlConnection and connection pooling

    William \(Bill\) Vaughn, Nov 14, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    508
    William \(Bill\) Vaughn
    Nov 14, 2003
  4. =?Utf-8?B?UGllcnNvbiBD?=

    Connection Pooling, Dispose/Close/Using

    =?Utf-8?B?UGllcnNvbiBD?=, Oct 14, 2004, in forum: ASP .Net
    Replies:
    9
    Views:
    4,663
    speedy
    Nov 26, 2008
  5. Edward W.
    Replies:
    5
    Views:
    3,323
    =?Utf-8?B?SEFSSSBQUkFTRCBCQVJV?=
    Dec 15, 2004
Loading...

Share This Page