TimesTen is a powerful, easy to use and fast in-memory database.
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
TimesTen is being used as an in-memory relational database for a multi-threaded real-time application. This application reads, writes and updates the data in TimesTen. TimesTen is also being used by a front-end graphical user interface to allow users to view the data and create reports. One problem with TimesTen is slow performance for larger sized tables and slow initial loading of TimesTen database. Another problem that was discovered is that TimesTen is not as fast as caching data using STL maps.
Pros
- With basic database experience, TimesTen has a very short learning curve.
- The installation and setup is easy and straightforward. The command line instructions are easy to follow.
- The error logging mechanism is simple and efficient. The system log files are helpful in troubleshooting problems with using TimesTen.
- The maintenance tools are user friendly and effective. Upgrading is easy and quick. TimesTen is almost a self-administrating database.
Cons
- Provide better monitoring tools of TimesTen daemon, servers and connections.
- Improved support for APIs. The libraries lack the necessary code for applications to customize for applications using TimesTen.
Likelihood to Recommend
TimesTen is well suited for applications using smaller data or smaller data stores and where transaction response times are not as business critical. TimesTen is good for applications already accessing Oracle and need to cache data for quick read/write operations. TimesTen is not appropriate for large data dependent applications or applications requiring fast response times. In these cases, using Oracle database or Exadata is better.
Vetted Review
5 years of experience