Click here to Skip to main content
13,189,324 members (69,318 online)
Rate this:
Please Sign up or sign in to vote.
Heya fellow CoProjs,

We need a good solution for an in-memory DB (not a hybrid solution, a pure in-memory one).
We run a server farm on strenuous efforts of several weeks at a time, in which we use 100% CPU on all continuously!
We are now looking into performance improve by moving the Worker application to perform strictly in-memory till it is finished (a periodical task performed each time with different params).

At the end we want to take the DB and save it as a file and\or migrate it to another File based DB like SQL Server or Oracle.

I've heard of TimesTen, eXtremeDB, SAP Hana, and there are rumors about MS to unvail an in-memory DB in the next shipment of SQL Server!!

However, I'm not experienced with all the above too much, and I'd like recomendations if you can spare a minute,

Major requirements are:

- Top performance (over 100K transactions per second)
- Cross Platform, i.e. both Linux and Windows (not a must be very very nice-to-have
- Not an Appliance
- Preferably possible embed in the code, like using DLLs and compiling the DB in your project (I know eXtremeDB and Raima work this way, perhaps others too)
- Ability to work with clustering (advantage)
- Ability to save the file at the end of the process

So the question is, I guess, what to pick, when and why? :)

Posted 10-Jan-13 3:49am
Updated 10-Jan-13 4:03am
Not a correct question, in fact. To pick one? On the base of what criteria? Who knows your purpose, except your?
Relational? Why? Object-oriented? (Easy in case of pure memory...) Why?
Edo Tzumer 10-Jan-13 10:03am
Added major requirements
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try the following site :[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


After benchmarking around 8 of the top solutions in the market,
We've come up with Oracle's TimesTen, and McObject's eXtreneDB as suiting for the job, just to get the impression of things: both answer for over 300,000 inserts per second!

Prices are around $100K-$400K depending on your licensing requirements, how many CPUs Processors etc.


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.171016.2 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100