您可以尝试使用基于列的数据库.这些类型的数据库在您描述的那种类型的分析查询上要好得多.有几种选择:

You could try making use of a column based database. These kinds of databases are much better at analytical queries of the kind you're describing. There are several options:

http://en.wikipedia.org/wiki/面向列的DBMS

我们在InfiniDB方面拥有丰富的经验:

We've had good experience with InfiniDB:

http://infinidb.org/

Infobright也看起来不错:

and Infobright looks good as well:

http://www.infobright.com/

InfiniDB和Infobright都有免费的开源社区版本，因此，我建议使用这些版本来获得一些有关可能获得的性能优势的基准.

Both InfiniDB and Infobright have free open source community editions, so I would recommend using these to get some benchmarks on the kinds of performance benefit you might get.

您可能还希望查看数据分区以提高性能.

You might also want to look at partitioning your data to improve performance.