Skip to main content
A
Anonymous
May 18, 2006
Question

client variable storage setting

  • May 18, 2006
  • 1 reply
  • 208 views
Here is a little question hope someone can shine some light on it.

Right now I am using the database as the client variable storage in CF (with options of Purge data for 1 day and Disable global client variable updates ). But it gives the database server a really heavy load (50-90% CPU usage average) and I believe this is the bottleneck of the time it takes CF serving the pages. I was wondering that is this good idea to put the client variable storage back to the Registry or cookie (for a quick fix until we upgrade the servers in 4 weeks)? We have average of 46000 page view/day and 9000 visits/day.



CFMX 6.11 apply the Hot fix for client variables already

Win2003

P4 with 2gb ram


Thanks
    This topic has been closed for replies.

    1 reply

    A
    Anonymous
    May 19, 2006
    It is a bottleneck. But on 46k pages views with that high of a CPU load, you must really have a very undersized db server. We're doing 3 million page views/day and about 65% of those use client variables and it doesn't even phase our db server.

    Putting them into a cookie shoudl work just fine. I wouldn't use the registry setting. It'll make a mess of your registry.

    You should consider session variables where possible. Those stay in server memory.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices