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?
Re: Scratch (Transient) Table
[QUOTE] 3 insert and 3 delete and 9 update per second, and the total rows number keeps on about 3,000./QUOTE]
This is trivial. Just use a regular table.