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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA Sent: Thursday, March 25, 2004 11:05 PM To: oracle-l@xxxxxxxxxxxxx; LazyDBA.com Discussion 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------