You would only store variables in the database for persistance
reasons. IE read it in once, and then use regular variables. A good
database driven application minimizes it's use on the database, as every
hit is very expensive.
On Thu, 8 Mar 2001, David Meyler wrote:
>
> Is there a big advantage to storing variables in the DB? I would assume
> this takes the dependency on RAM away. Any thoughts?
>
> "store them in a "Data Base".
> Indicating a Data Base Cold Fusion will create the necessary tables to
> store the variable."
>
>
>
>
> -----Original Message-----
> From: Saul G. Perez [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Thursday, March 08, 2001 8:04 AM
> To: CF-Server
> Subject: RE: naything wrong with heavy use of session vars?
>
>
> Client variables are ideal for clustered environments, however there is
> no doubt that Session Variables are much quicker than client variables.
> Session variables use memory on the machine and depending on the RAM on
> that physical machine and the use they can be detrimental to that
> server. Under cold fusion administrator you can specify/choose whether
> to choose your session variable in the "Registry" or in a "Data Base".
> Indicating a Data Base Cold Fusion will create the neccessary tables to
> store the variable. I have a few documented ways of transitioning from
> session variable to client based variables. (I will forward these once I
> find the links)
>
>
>
> -----Original Message-----
> From: Kola Oyedeji [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Thursday, March 08, 2001 1:45 AM
> To: CF-Server
> Subject: naything wrong with heavy use of session vars?
>
>
> Hi all, this may already been covered, but recently i have been reading
> a
> lot of posts on
> strongly discouraging session vars and using client vars instead.
> Becuase
> session variables are held in memory can too many of them cause the
> system
> to become unstable?
>
> I was contemplating
> changing all my session vars to client vars when i read a post on the
> Allaire forums from a
> member of allaire:
>
> "client variables should be used lightly, anyway- they are not the most
> efficient thing we have. Always encourage the use of them to be
> minimal."
>
> so basically how less efficient can client vars be over session
> variables? I
> know client variables do not need locking and can be clustered but are
> these
> the only 2 advantages?
>
> Any comments? Thanks
>
> Kola
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
