Re: database in memory

Sounds rather 'marketing-led' to me. I'd love to challenge them on 10 times the performance of Oracle with a small db and a large SGA.

MotoX.

Art S. Kagel wrote in message <35C8A7A4.7A8A_at_bloomberg.net>...
>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 Thu Aug 06 1998 - 06:23:51 CDT