== Initial download ==

To initially download the benchmark code,

cvs -d :pserver:anonymous@cvs.pgfoundry.org:/cvsroot/tpc-w-php login
cvs -d :pserver:anonymous@cvs.pgfoundry.org:/cvsroot/tpc-w-php checkout tpcw-benchmark
mv tpcw-benchmark tpc-w-php

Despite the CVS checkout, this appears to be the stable source of the
source and documentation.  It is mostly a bulk load from some other
site.

== Creating the database ==

createuser -SdR apache

export PATH=$HOME/sandbox/txcache/pg/bin:$PATH
cd src/tpc-w-php/data_generation
make
# Old way: ./pop_100EB_1000ITEM.sh pgsql
./pop.sh 100 1000

createdb tpcw_100_1000
createlang plpgsql tpcw_100_1000
psql tpcw_100_1000 < load_pgsql_100EB_1000ITEM.sql

== Create images ==

cd src/tpc-w-php/image_generation/ImgGen/ImgFiles
make
cd ../..
./generate_images.sh 1000

== Set up Apache ==

openssl req -new -newkey rsa:1024 -days 365 -nodes -x509 -keyout tpcw.pem -out tpcw.pem -subj /CN=localhost
pushd /etc/apache2/sites-enabled
sudo ln -sf ~/sandbox/txcache/src/tpc-w-php/apache-tpcw-austin 001-tpcw
popd
sudo a2enmod ssl
sudo a2ensite default-ssl
sudo /etc/init.d/apache2 restart

== Configuring TPC-W ==

cd src/tpc-w-php/html/tpcw
sed 's/port=9999/port=5432/' config.inc.sample >config.inc

== Running ==

cd src/tpc-w-php/RBE
# Fix web_server in run_RBE_100EB_1000ITEM.sh
./run_RBE_100EB_1000ITEM.sh

== Interpreting the results ==

octave
source mix2_100of100EBS_1000ITEMS.out
mean(tpcw().wips(300:1500))