Re: Reports with Stores Procedures

[Rick James]

Your plan should work.

Suggestion:
Each night create and fill table new_xx, then do
RENAME TABLE report_xx TO old_xx, new_xx TO report_xx;
That way, a report is always available, even while the report is being regenerated.

I prefer "summary" tables. I periodically condense new information from the big, raw, table into summary tables. My "reports" read summary tables, not the raw data, and are fast enough to build the report in realtime.

1M rows; 150 tables -- no problem. If you do have trouble, provide specifics (table schema, explain, etc).