Hi Andy
Yes, this is real, and we stopped using client variables because of it. I
suspect that most of the load is spent updating the
last-time-someone-visited-the-site information in the database tables... it
has to do this on every hit, whether or not the client even has any client
variables.
Did you ever try one of the other methods like cookies or the registry?
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 11:30 AM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Hi Andy
Yes, this is real, and we stopped
to worry with
given the benefits they offer.
Ken
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 2:30 PM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Hi Andy
Yes, this is real, and we stopped using client variables because
or the registry?
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 11:30 AM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Hi Andy
Yes, this is real, and we stopped using client variables because of it. I
suspect that most of the load
like cookies or the registry?
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 11:30 AM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Hi Andy
Yes, this is real, and we stopped using client variables because of it. I
suspect
Yep, afaik CF ( at least prior to MX ) hits the db for each reference to
those client variables... If you're concerned about the overhead, you could
copy all your client variables to the request scope at the top of the page,
i.e. in your application.cfm and then use the request variables
client variables are stored.
Ken
-Original Message-
From: Andy Clary [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 3:25 PM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Ken, thanks for the info on how to disable global client variable
updates. I never
Andy Clary wrote:
I am approaching the problem from the perspective of tuning our
database for performance. My concern is that SQL Server is seeing a
lot of statements come across that update client variables and it may
be optimizing the buffer cache in light of this. So, when valid
:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 11:30 AM
To: CF-Talk
Subject: RE: Client Variable Storage and SQL Server
Hi Andy
Yes, this is real, and we stopped using client variables because of it. I
suspect that most of the load is spent updating the
last-time-someone-visited-the-site
S. Isaac Dealey wrote:
Yep, afaik CF ( at least prior to MX ) hits the db for each reference
to those client variables... If you're concerned about the overhead,
you could copy all your client variables to the request scope at the
top of the page, i.e. in your application.cfm and then use
, 2002 12:49 PM
To: CF-Talk
Subject: Re: Client Variable Storage and SQL Server
S. Isaac Dealey wrote:
Yep, afaik CF ( at least prior to MX ) hits the db for each reference
to those client variables... If you're concerned about the overhead,
you could copy all your client variables
Thanks Jochem ... I had a feeling that was the case, but never knew for
certain... :) I read pretty slowly and there's probably a lot of CF
documentation I haven't read...
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
S. Isaac Dealey wrote:
Yep, afaik CF ( at
12 matches
Mail list logo
