# what different between aggregation table and analytics table?

Hi,sir,
I still not clear understand the diff and relation of the two kind table. can give some explane?
will the analytics table replace aggregation tables?
Thanks.

···

easy.

Hi,

the tables starting with aggregated… is for pre-aggregated data and referred to as a data mart. We keep this for legacy reasons and because it is sometimes easier to integrate with SQL-based analysis tools.

The analytics tables are used by the analytics Web API and should ideally not be used directly. The analytics API aggregates data on-the-fly and is much more flexible and less time-consuming.

Lars

···

On Sat, Aug 17, 2013 at 6:29 AM, easy lin_xd@126.com wrote:

Hi,sir,
I still not clear understand the diff and relation of the two kind table. can give some explane?

will the analytics table replace aggregation tables?
Thanks.

easy.