Scratch (Transient) Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Scratch (Transient) Table

Threaded View

  1. #1
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width