MySQL: Is it safe to have a table with multiple millions of rows?
If your data can be pre-calculated and is static intra-day then why not? 
After all, isn't this what a data warehouse does?

As for having up to 50 million rows, this is peanuts.