Skip to main content
_
_Michael___
Participant
April 29, 2013
Question

Problems with client variables storage.

  • April 29, 2013
  • 1 reply
  • 303 views

I have a couple of problems with my client variable storage on CF8.

Storage is in a sql server db:

  • cdata has no data.
  • cglobal is growing very quickly.  It seems that every new page request is generating a new entry on this table.  I have some ajax requests that poll every second, so it's hammering the db and slowing everything down.

Any ideas as to how I can debug either of these issues would be welcome, thanks.

This topic has been closed for replies.

1 reply

_
_Michael___Author
Participant
April 29, 2013

create index ixCfid on  COLDFUSION_ClientVariableStore.dbo.cglobal (cfid)

This seemed to help a lot with the page load times.

Ticking Disable global client variable updates in the Administrator stopped the exponential db growth.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices