PGD has been optimized using the following techniques
SQL Indexes SQL Aggregate Functions In Memory Tables Denormalized Search Table