Session Variables and reclaiming associated memory.

Discussion in 'ASP General' started by Mario, Feb 18, 2004.

  1. Mario

    Mario Guest

    If there is an associated memory cost for using session variables, can
    the memory used be reclaimed on an ASP page by setting the session
    variable to undefined or null? If on the same ASP page you use a
    different session variable name and after each refresh of the page,
    set the previous session variable to undefined before using the next
    session variable, does this reclaim the memory used in the previous
    session variable, or does the usage of memory just continue to grow
    with each page refresh?

    Tex
     
    Mario, Feb 18, 2004
    #1
    1. Advertising

  2. Mario

    swp Guest

    (Mario) wrote in message news:<>...
    > If there is an associated memory cost for using session variables, can
    > the memory used be reclaimed on an ASP page by setting the session
    > variable to undefined or null? If on the same ASP page you use a
    > different session variable name and after each refresh of the page,
    > set the previous session variable to undefined before using the next
    > session variable, does this reclaim the memory used in the previous
    > session variable, or does the usage of memory just continue to grow
    > with each page refresh?
    >
    > Tex


    When you say "undefined" above do you mean "nothing" or ""?

    for example, which of these is appropriate to your situation:
    DIM con, rs, sql
    sql = "SELECT name, addr1, addr2, city, state, zip FROM people WHERE
    flag<>'D' ORDER BY name"
    set con = server.CreateObject("ADODB.Connection")
    con.Open db_name, username, password ' fill in with your own system
    dsn link and connectivity information
    set rs = con.execute(xsql)
    .... process stuff ...
    con.close
    set rs = nothing
    set con = nothing

    swp
     
    swp, Feb 18, 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. Replies:
    1
    Views:
    965
  2. Thomas Rast

    Reclaiming (lots of) memory

    Thomas Rast, Oct 2, 2004, in forum: Python
    Replies:
    11
    Views:
    574
    Luis P Caamano
    Oct 22, 2004
  3. CJ

    Reclaiming locks

    CJ, Oct 29, 2007, in forum: C Programming
    Replies:
    6
    Views:
    335
    David Schwartz
    Oct 30, 2007
  4. softwarepearls_com

    Reclaiming this group for Java enthusiasts

    softwarepearls_com, Sep 29, 2008, in forum: Java
    Replies:
    4
    Views:
    403
    Arne Vajhøj
    Oct 4, 2008
  5. Myth__Buster
    Replies:
    14
    Views:
    525
    Myth__Buster
    Feb 3, 2011
Loading...

Share This Page