The feeling that I'm missing something with noSql solutions, comments are welcome
There is a plate with 100-200 million records, sorted by time where you want to quickly execute queries of the form
select time field, sum(field2)
from t inner join t2 on ...
where field3 = x and field = y
and time between time1 and time2
group by time, field
order by time
now all that lives on one server to sql server and the problem is that the indexes for this table takes the same place as the data.
What noSql solutions are well suited for such a task? I still managed to watch just for CoachDb — the species does not fly