1 从http://www.tpc.org/tpch/specs.asp下载
TPC-H Version 2.14.3 栏目里的tar文件
上传到linux
2 tar -zxvf
3 cp makefile.suite makefile
vim makefile
CC = gcc
DATABASE = SQLSERVER
MACHINE=LINUX
WORKLOAD = TPCH
4 vim tpcd.h
#ifdef SQLSERVER
#define GEN_QUERY_PLAN "EXPLAIN;"
#define START_TRAN "START TRANSACTION;\n"
#define END_TRAN "COMMIT;\n"
#define SET_OUTPUT ""
#define SET_ROWCOUNT "limit %d;\n"
#define SET_DBASE "use %s;\n"
#endif
5 vim dss.h
/*#define PR_END(fp) fprintf(fp, "\n")*/ /* finish the record here */
#define PR_END(fp) {fseek(fp,-1,SEEK_CUR); fprintf(fp,"\n");}
6 执行make命令,生成dbgen可执行文件
7 ./dbgen -s 1 生成1g数据
./dbgen -s 10 生成10g数据
./dbgen -s 100 生成100g数据
TPC-H Version 2.14.3 栏目里的tar文件
上传到linux
2 tar -zxvf
3 cp makefile.suite makefile
vim makefile
CC = gcc
DATABASE = SQLSERVER
MACHINE=LINUX
WORKLOAD = TPCH
4 vim tpcd.h
#ifdef SQLSERVER
#define GEN_QUERY_PLAN "EXPLAIN;"
#define START_TRAN "START TRANSACTION;\n"
#define END_TRAN "COMMIT;\n"
#define SET_OUTPUT ""
#define SET_ROWCOUNT "limit %d;\n"
#define SET_DBASE "use %s;\n"
#endif
5 vim dss.h
/*#define PR_END(fp) fprintf(fp, "\n")*/ /* finish the record here */
#define PR_END(fp) {fseek(fp,-1,SEEK_CUR); fprintf(fp,"\n");}
6 执行make命令,生成dbgen可执行文件
7 ./dbgen -s 1 生成1g数据
./dbgen -s 10 生成10g数据
./dbgen -s 100 生成100g数据