caching - ColdFusion Client Variable Showing Outdated Value Intermittently -
we have legacy coldfusion application using 150 client variables manage session state. client variables centrally stored in sql server database within 6 application server clustered environment using round-robin load balancer. the problem when code updates client variable new value, old value still being used , displayed though new value updated appropriately in cdata table. happens intermittently in average of 1 out of 1000 updates being made client variable using cfset tag. race conditions , caching issues possible explanations. “suspect” old value still being cached on 1 of 6 application servers. adobe's documentation states client variables cached memory not go further details. 1) has experienced issue , found resolution? 2) implications of moving sticky session while keep using client variables? i think first take closely @ database commits. client vars retrieved @ "beginning" of request , updated @ "end" of request changes. consider ...