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 ( a
October 14, 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
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
> 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
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
cation-specific 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
u
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 instead..
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, t
r 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
. Not enough 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 c
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
]]
Sent: Monday, October 14, 2002 1:13 PM
To: CF-Talk
Subject: Client Variable Storage and SQL Server
We are using SQL Server to manage our client variables and I've noticed that
a majority of the SQL commands hitting our server are from Cold Fusion
managing client variables. Has anyone else no
We are using SQL Server to manage our client variables and I've noticed that
a majority of the SQL commands hitting our server are from Cold Fusion
managing client variables. Has anyone else noticed this type of activity?
Just a simple trace in SQL Profiler revealed statements like:
SELECT data
13 matches
Mail list logo
