I have a multi-page form (survey) where the user can go forward and back through the survey. I want to save the entries from each page so that I can repopulate the page if the user goes back to it. I expect to have 30-40 surveys a day. Is it better to store the data for the survey in an array of structures (CategoryID, QuestionID, AnswerValue) and then submit all the data in one pass when the user finishes the form, or save each page to the database as the user moves through the form, and then go back to the database for the data if they go back to an earlier page? I've always thought it was best to only hit the database once at the end, but I've been reading that some people recommend going to the database every time a page is submitted, because storing the data as an array of structures takes up RAM.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
