Re: database in memory

Aaron Bradford wrote:
>
> Hey all,
>
> I was curious if anyone has run into a product for oracle that is
> similar to the codebase library. codebase allows you to do things in
> memory then writes them to a database. I'm looking at a database in
> memory with a thread that writes back to oracle. The database would
> have one table of 33 megabytes. could I pin the data in the sga and get
> the same speed results?. Codebase is very fast because everything is in
> memory. It has no problem updating 1,000 rows in a second. Any products
> or ideas would be helpful. We want to try to come as close as possible
> to realtime processing.

I just looked at a product called TimesTen from TimesTen Performance Software. They have a full relational DBMS that resides in memory with a backup on disk that it loads into memory at startup and flushes all mods to automatically. They claim 10X Oracle/Informix performance levels even after Oracle or Informix loads the tables into memory buffers. Worth a look (www.timesten.com).

Art S. Kagel Received on Wed Aug 05 1998 - 13:42:44 CDT