TABLE 7: MDX vs. SQL Query Processing Times
Query Number Time in Seconds for MDX Query on OLAP Server, Using MOLAP with 30% Aggregation Time in seconds for SQL Query on SQL Server Approximate Number of Records Accessed
1 48 134 13 million
5 70 95 543,000
6 1 126 13 million
7 1 126 13 million