Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Embedded databse
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? Smile | :)
 
Cheers,
Edo
Posted 10-Jan-13 4:49am
Edited 10-Jan-13 5:03am
v3
Comments
Sergey Alexandrovich Kryukov at 10-Jan-13 9:52am
   
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?
—SA
Edo Tzumer at 10-Jan-13 10:03am
   
Added major requirements
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try the following site : http://nosql-database.org/[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Solved!
 
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.
 
Cheers,
Edo
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 386
1 Marcin Kozub 225
2 Sergey Alexandrovich Kryukov 215
3 /\jmot 189
4 Praneet Nadkar 173
0 OriginalGriff 8,289
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,624
3 Maciej Los 4,989
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2014
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