A good approach to db planing for reporting service
- by Itay Moav
The scenario:
Big system (~200 tables).
60,000 users.
Complex reports that will require me to do multiple queries for each report and even those will be complex queries with inner queries all over the place + some processing in PHP.
I have seen an approach, which I am not sure about:
Having one centralized, de-normalized, table that registers any…