Re: database in memory

MotoX wrote:
>
> 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.

Obviously I am qouting their RA-RA stuff. They SAY that their tests were performed against Oracle, Informix and other RDBMSs after the entire database had been coerced into the engine's buffer cache. I'm not promoting the product or selling it. However, I had been looking through their sales literature and web site and looked over their benchmark report and it seemed to me to be something that Aaron should at least look at.

They claim to use algorithms and indexing structures that would be horrendously inefficent for a disk-based database server but that are optimal for a memory based server. FWIW!

> 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 - 10:28:55 CDT