One million new records a month is less than one new record a second. Ten million new records a month is almost four new records a second (slightly more than four if the month is February!). That is not a challenging level of performance for any database, relational or otherwise.
It is indeed the millions-per-hour order of magnitude where things get interesting.
It is indeed the millions-per-hour order of magnitude where things get interesting.