It's a bit like comparing the performance of a Formula 1 to the performance of a tank. In-memory databases, in general, will vastly outperform databases that rely on writing to disk, much like the Formula 1 car will vastly outperform traditional databases like Oracle on a smooth track. An in-memory database generally requires that you have enough RAM to hold the entire database and does not have anywhere near the guarantees of durability (the D in ACID) that a traditional database does. Tanks are built to withstand a lot more for a lot longer than a Formula 1 car is.
If you have a small, read-only or read-mostly database where you can afford to lose updates, an in-memory database is probably ideal. Otherwise, stick with the traditional database.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@(protected)
Sent: Thursday, March 25, 2004 11:05 PM
To: oracle-l@(protected)
Subject: Timesten Vs. Oracle - Performance
How does timesten compare with Oracle Database in performance, availability etc?
Timesten in-memory Database - a brief :-
The database system needs an inexpensive, plentiful memory, and the dramatic increases in processor speeds relative to the modest increases in disk drive performance.TimesTen produces software that brings real-time database performance to applications. With TimesTen In-Memory Database Technology,throughput is measured in tens of thousands of operations per second, and response times are counted in microseconds.
Though internally unique, TimesTen's products are accessed through standards-based interfaces, and designed for easy integration into existing software infrastructures.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected).
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
