DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Threaded View

  1. #1
    Join Date
    Apr 2002
    Shenzhen, China

    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 03: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