Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tiflash
Does TiFlash support multi-table join for correlation analysis? I saw in the documentation that the QPS is not high.
Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tiflash
Does TiFlash support multi-table join for correlation analysis? I saw in the documentation that the QPS is not high.
Supported, but it’s best not to set the concurrency of TiFlash too high, otherwise it might cause an OOM (Out of Memory) issue.
TiFlash is very suitable for scenarios involving joins of multiple large tables, and it has MPP and other strategies for specialized optimization, making it very adept at handling large SQL AP analysis. For business scenarios involving large data volume calculations, the focus is mainly on high throughput and large capacity calculations, with high QPS being relatively less important and unnecessary.
There is also a similar post in the forum that you can check out: tidb支持两张一亿级别的数据表进行join关联数据分析? - TiDB 的问答社区