Which In-Memory DG/DB to choose?

Question

Database

Hello fellow toasters. I need your help again :) I need a low latency database that can work with a relatively small amount of data of 100-300k rows, but most importantly, that can filter these rows by 12-15 parameters and give the result in less than 5ms. After many hours of googling, I came across such a thing as In-Memory Database and In-Memory Data Grid. I found more than a dozen options, but I just can’t find the right one for me.
Key requirements:
- Low query latency
- Data persistence (something like Write Ahead Log)
- Presence of a more or less convenient client for .net core
I tried Redis and Tarantool, but they didn't work for me. Radish is more suitable for cache. I liked the Tarantula more, the delay is excellent, often less than 1 ms, but I've been tinkering with it for the third day already, and several points stop, namely, the absence of some data types, a low-level client for .net core and not the most detailed documentation.
Such are the things. Ideally, I hope to hear from you the names of cool and convenient IMDB and IMDG :)
Many thanks in advance to everyone!

Answer 1

if we are talking about .net, then the dataset with tables lives quite well in memory, and selections can be made through LINQ