Last post May 24, 2014 03:37 PM by Xequence
May 19, 2014 09:30 AM|lajo|LINK
I am looking to design an application in visual studio .NET/C# which need to be super fast despite relatively large amounts of data, hence the need for an in-memory database. I would prefer to use Entity Framework (EF). Question is which in memory database
that is best suited for me using .NET/EF? I am guessing that it is possible to use both eXtreme DB, SQL CE, SQLite and others.
Also, when is .NET caching a good alternativ to an in-memory database?
May 19, 2014 03:38 PM|CASPartan|LINK
Have you considered using a Solid-State Drive (SSD) for your database (and/or server)? It will be akin to almost having an in-memory database since the data will be stored in faster RAM instead of hard disk spinning platters.
Another advantage of SSD is persistence, so even if you lose power, your data is still safe since they're not stored on volatile memory.
May 24, 2014 03:37 PM|Xequence|LINK
I would take into account your client technologies. If you use wpf, you can have them use the data file locally. if it is a webapp, you will want to give the illusion of speed through asynchronous calls. in a webapp you can also use localstorage to hold
onto your records.
json is light weight enough to allow the browser to handle 50k request in a blink of an eye.