Is there a in-memory database that can be coupled with an Ms sql server.ie i will use an in memory database system as a cache and the ms sql as my main backend database. forexample- Timesten integration with oracle.
Thanx.
Asked
Active
Viewed 3,412 times
1 Answers
1
Yes! To stick with the Microsoft stack, check out App Fabric: http://en.wikipedia.org/wiki/AppFabric#AppFabric_Caching
It's an in-memory distributed cache where you can effectively cache your database calls so your client doesn't have to constantly hit the database.
I've used it in production and it works pretty well. You can easily fire up new nodes when you need to scale and they'll join the cluster and data gets re-distributed automatically.
ryan1234
- 7,237
- 6
- 25
- 36
-
is there any standlone DBMS that can do the same? – Joe Dominic Valluvassery Apr 12 '13 at 04:19
-
A stand alone database that provides caching? – ryan1234 Apr 12 '13 at 20:13
-
yes! a standalone in memory RDBMS that can act as cache to an existing database. – Joe Dominic Valluvassery Apr 13 '13 at 07:16