# Aggregate Operations Solutions

+ When the data in the table is not update frequently
  + Enable**copr-cache** on the compute node**TiDB** (TiDB 4.0 introduced, enabled by default)


![left](./student-guide/diagram/01-34-1.png)

------------------------------------------------------------

In the first case, if our table data has few DML operations, and the query pattern is fixed, you can enable copr-cache on the compute node TiDB (introduced in TiDB 4.0 version, enabled by default). This will cache the execution results of COP at region granularity based on the LRU algorithm, so that after query once, if The data of the relevant region has not changed. The next query does not need to access TiKV to directly query the previous execution results of the TiDB layer's cache, and the performance will be significantly improved.