Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Use session variables or store in database?

Reply
Thread Tools

Use session variables or store in database?

 
 
eselk@surfbest.net
Guest
Posts: n/a
 
      07-06-2005
I'm new to ASP. If I store information in these handy "session
variables" am I going to run into many limitations that I wouldn't have
it I added a database record for each session instead? For example, if
I use session variables, can I have an admin utility that lets me see a
list and/or count of all open sessions? Or would I be able to keep the
same user from starting multiple sessions if I wanted (by comparing the
log-in name which my web-site requires)? I know if I create a record
for each open session that I can do all kinds of fun stuff like reports
and queries, but not sure if I'll have all of those options with these
built in ASP session variables (which I imagine ASP stores in memory or
some non-standard format).

p.s.-I'm using ASP (not ASP.NET) with VBScript (I hate VB syntax but
that is what everyone seems to use).

 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      07-06-2005
wrote:
> I'm new to ASP. If I store information in these handy "session
> variables" am I going to run into many limitations that I wouldn't
> have it I added a database record for each session instead? For
> example, if I use session variables, can I have an admin utility that
> lets me see a list and/or count of all open sessions?


No

> Or would I be
> able to keep the same user from starting multiple sessions if I
> wanted (by comparing the log-in name which my web-site requires)?


No

> I
> know if I create a record for each open session that I can do all
> kinds of fun stuff like reports and queries, but not sure if I'll
> have all of those options with these built in ASP session variables
> (which I imagine ASP stores in memory or some non-standard format).
>


You need a database. Look at:
http://www.aspfaq.com/show.asp?id=2491
http://www.aspfaq.com/show.asp?id=2078

> p.s.-I'm using ASP (not ASP.NET) with VBScript (I hate VB syntax but
> that is what everyone seems to use).


Not everyone. A few people on this list use jscript exclusively. Nothing
says you have to use vbscript.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


 
Reply With Quote
 
 
 
 
eselk@surfbest.net
Guest
Posts: n/a
 
      07-07-2005
Wow, thanks for the super fast reply! I'll check out those links, and
also look over the rest of the FAQ.

 
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
How to use a class property to store function variables? GZ Python 10 04-28-2010 08:08 AM
Put variables into member variables or function variables? tjumail@gmail.com C++ 9 03-23-2008 04:03 PM
How to use session to store data..Plz Help... sanju ASP General 1 05-14-2007 11:45 AM
Store session variables in a form Fernie HTML 6 11-23-2004 12:44 AM
Store shell session/cmd.exe session in some object? Zach Dennis Ruby 2 01-08-2004 10:07 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57