TPCH Issues

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tpch 问题

| username: GreenGuan

Could you please advise on how to use the tiup sysbench tpch command to load data of a specified size, such as 100G? Is it the sf parameter? I couldn’t find any relevant information after searching for a long time.

| username: WalterWj | Original post link

You can try specifying the number of rows, then check the corresponding space growth in TiDB, and convert it according to this amount.

| username: zhaokede | Original post link

SF can only indirectly affect the size of the data. You can find an appropriate SF value through experimentation and estimation to generate test data close to the amount you need (100G).