Store frontend values in backend
676060Apr 6 2011 — edited Apr 6 2011Hi All,
I have an unique problem, i have my application written in Java and the backend is Oracle. The application passes frontend values(user input) to the backend. These values are temporary, based on these values the backend would do whatever insert and update processes to be done on the backend objects. At the end of the user session these values are no more needed. Can anybody point me out any temporary storage for these variables in backend. My biggest concern is the DB performance, if many users simultaneously accesses the application there should be minimal load on the backend.
I had thought to use Global Temporary Tables for each user session, but that would a burden on the database when many users accesses the application simultaneously.
Thanks in advance.