Wednesday, August 21, 2013

0 Use TPC-H to create large test data sets

 

Prerequisite

Install Visual Studio Express 2012 for Windows Desktop

Download the TPC-H

Compile the dbgen.exe

Open the tpch.sln from the tpch_2_16_0\tpch_2_15_0\dbgen\ and click the BUILD.

image

There would be some error, however, the ddlgen.exe still create successfully under Debug folder

image

However, when I tried to excute the dbgen, I got the error “can not access dists.dss” file.

image

The file is in the same folder tpch.sln. just copy to the Debug folder.

Another issue is that the bm_utils.c is only read the relevant path of the dists.dss. therefore we have to run the dbgen,exe in the Debug folder.

image

The data would be created at the same folder.

image

The ddl schema is in the dss.dll ( is in the same folder tpch.sln.)

Now we can use dbgen to generate the large sample database for testing.

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates