Note in my first post I said "...You are ***supposed*** to be able to fix this by adding ..."
I'm afraid my experience mirrors yours. However, did you try deleting the cookies your test system had already set to see if a fresh start solved the issue? That may be what it takes to get this accomplished... but then again if you are trying to refit an app you'll have zillions of existing users for whom you will also have refit -- manually with a cookie deletion. Do-able but pesky. You are using client variables as they are actually meant to be used -- truly long-term persistent storage. I use them in place of session vars because I am stuck with CF5 clustering support, expire them within minutes and not weeks etc. Given the traffic levels you referenced elsewhere, you must have an enormous cvar database -- as in lots of records -- if as you say you are storing those records for months. IIRC, if CF creates the cvar db's itself they aren't indexed so well. Have you thought to look into this and maybe make an adjustment there? I'm going off of hazy recollection here so I may be wrong, but its worth looking into. What is your db platform, anyway? Is it on the same server? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
