The hardware can help but the aggregation like sum seems to not use the cache. I created temporary table and used that as my bases for the query and it returned the result set in 1 sec where the original query took 30 sec. Thus, the ultimate question is when I run the aggregation select statement twice...