Best NoSQL database for .NET for storing multi-minute statistics with time index?

Question

I need to store 10 minute statistics per minute with a time index (and do the calculation). I do not want sql db, but NoSQL. What would be better for .NET?

For the better, I mean:

1 °) Performance (for quick reading, to perform a calculation in 2) 2 °) It is easy to make a calculation, for example, average from a point in time, for example 3 °)

Answer 1

The best for ".NET" is subjective. The only one that is built using .NET, RavenDB , but others, such as CouchDB and MongoDB also have “drivers” that allow them to be queried using a set of .NET libraries, so from the client they can all be used in a .NET application.

Although they all work on Windows as well, I think it’s more about the platform you plan to run. Check here for the language in which they are developed, it may be more difficult to install and maintain something developed in Erlang, in my opinion.

Another note is the way indexes are created. In RavenDB, you create indexes and map / reduce functions in .NET with Linq. In CoucbDB, you are using Javascript.

Answer 2

How to use application cache?

This is actually not a database, but it will bring performance, and it works in NoSQL Key / Value mode. The downside would be storage space, but you could build your own system to store both permanent storage in the database and temporary storage in the cache for calculations. Another drawback if you work with multiple servers: you need to worry about cache availability on multiple machines. Some flaws, but HUGE performance benefits IMO.