Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Store frontend values in backend

676060Apr 6 2011 — edited Apr 6 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2011
Added on Apr 6 2011
4 comments
504 views