Scratch (Transient) Table
We have a table of MEMBERS_ONLINE in a BBS application, and this table will have lots of DMLs, say 3 insert and 3 delete and 9 update per second, and the total rows number keeps on about 3,000.
What's your opinion to deal with it? I think Oracle is very inefficient in this case cause of undo and redo records generated along, and temporary table is impossible here for every session need to query this table.
I guess that a global memory collection maintained by JSP program would be a feasible solution?
Last edited by Calvin_Qiu; 04-05-2003 at 04:01 AM.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Reply With Quote