Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Session Variables and reclaiming associated memory.

Reply
Thread Tools

Session Variables and reclaiming associated memory.

 
 
Mario
Guest
Posts: n/a
 
      02-18-2004
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
 
Reply With Quote
 
 
 
 
swp
Guest
Posts: n/a
 
      02-18-2004
http://www.velocityreviews.com/forums/(E-Mail Removed) (Mario) wrote in message news:<(E-Mail Removed). com>...
> 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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reclaiming locks CJ C Programming 6 10-30-2007 07:10 AM
reclaiming hard drive space =?Utf-8?B?bG9hZGVyb3Bw?= Windows 64bit 10 04-10-2007 02:54 AM
Reclaiming (lots of) memory Thomas Rast Python 11 10-22-2004 01:18 PM
0 Kb of RAM left, reclaiming it ?? fredcromer Computer Information 8 06-19-2004 03:48 PM
Reclaiming Home Page in IE 6.0 Ron Flaman Computer Support 4 06-26-2003 05:18 PM



Advertisments