When you need to gather statistics and reporting data from a large number of transactions (easily >1’000’000 rows) you need to transfer that data over to a reporting-friendly format to keep request times down. One popular database design for this is called a Star Schema. This is a simple re-usable StarSchema setup for CakePHP.