Using Arrays vs Temp Tables for a user session
I am prototyping an event system app for a local organization. They are logging into the site and then API calls use their entered login info to retrieve information from other apps. The goal is to not store any long term "user data" since that is stored in the other apps. (by user data, I mean stuff for logins/settings/etc since its stored in those other apps). The info retrieved from the API calls is displayed to the user but is only needed for the length of the registration process.
Once the user registers for the event, the data gotten from the API calls and such should be deleted and the only data saved long term is the data that makes its way to the separate event registration table.
Is it better to do a temp table or to store the temporary information in a session variable/array? We are only anticipating maybe 500 concurrent users.