Database data is also less volatile than session data. If a person is called away from your signup process in the middle, and comes back after the session has expired, do you want them to be kicked back to start over? The answer might be Yes but you need to plan for stuff like that. One thing I would be leery of is relying on session vars on a shared CF server (i.e. a $20 or $50 monthly hosting account). If this is a box dedicated to your site I wouldn't worry so much, if at all.
There's no set rule for any of this, but definitely less db access a good thing. On 9/25/06, Richard White <[EMAIL PROTECTED]> wrote: > how do you feel about storing data in the session variable. as i think for > storing the data in it will be great as if they are navigating among pages > and come back to a page they were on before, then i would just check to see > if the data is in the session variables. This would drastically lessen on the > load on the database and the pre-processing needed for each page. > > but i see what you mean it depends on the amount of data that will be getting > stored in the session variable. if it is down to judgement, there are certain > wizards where the users will go through around 10 steps for each course they > are undertaking. at the end of these wizards the session variables holding > the data can be flushed. So i see what you mean it is all dependant on what > you are doing > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
