1 Reply Latest reply: Jul 26, 2012 4:29 AM by Tim Vincent RSS

    Should I use TimesTen for unstable table

    880143
      Hi all,
      I have a table that there are a lot of accessing operations to it, include: select, insert, update, delete. My table has 80 columns, about 1M rows, one primary key (2 cols), 5 indexes in other cols.

      I want to increase select speed.
      Should I use TimesTen Cache for this table? Which cachegroup type (read-only, awt, swt,...) I should use?

      Thanks!
        • 1. Re: Should I use TimesTen for unstable table
          Tim Vincent
          Sure you could use TimesTen to cache this table from the Oracle database. As you are performing DML against it I would recommend you look at the Asynchronous Write-Through (AWT) Cache Group.

          Start here -> http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21634/concepts.htm#BABFBIEC
          Info on AWT -> http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21634/define.htm#CHDJAJAC