#!/bin/bash

#

# This is a template for a script used for day-to-day size and

# performance monitoring of SQLite. Typical usage:

#

# sh run-speed-test.sh trunk # Baseline measurement of trunk

# sh run-speed-test.sh x1 # Measure some experimental change

# fossil test-diff --tk cout-trunk.txt cout-x1.txt # View chanages

#

# There are multiple output files, all with a base name given by

# the first argument:

#

# summary-$BASE.txt # Copy of standard output

# cout-$BASE.txt # cachegrind output

# explain-$BASE.txt # EXPLAIN listings (only with --explain)

#

if test "$1" = ""

then

echo "Usage: $0 OUTPUTFILE [OPTIONS]"

exit

fi

NAME=$1

shift

#CC_OPTS="-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_MEMSYS5"

CC_OPTS="-DSQLITE_ENABLE_MEMSYS5"

SPEEDTEST_OPTS="--shrink-memory --reprepare --stats --heap 10000000 64"

SIZE=5

LEAN_OPTS="-DSQLITE_THREADSAFE=0"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_DEFAULT_MEMSTATUS=0"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=1"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_LIKE_DOESNT_MATCH_BLOB"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_MAX_EXPR_DEPTH=0"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_DECLTYPE"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_DEPRECATED"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_PROGRESS_CALLBACK"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_SHARED_CACHE"

LEAN_OPTS="$LEAN_OPTS -DSQLITE_USE_ALLOCA"

doExplain=0

doCachegrind=1

while test "$1" != ""; do

case $1 in

--reprepare)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--autovacuum)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--utf16be)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--stats)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--without-rowid)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--nomemstat)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1"

;;

--temp)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS --temp 6"

;;

--wal)

SPEEDTEST_OPTS="$SPEEDTEST_OPTS --journal wal"

;;

--size)

shift; SIZE=$1

;;

--cachesize)

shift; SPEEDTEST_OPTS="$SPEEDTEST_OPTS --cachesize $1"

;;

--explain)

doExplain=1

;;

--vdbeprofile)

rm -f vdbe_profile.out

CC_OPTS="$CC_OPTS -DVDBE_PROFILE"

doCachegrind=0

;;

--lean)

CC_OPTS="$CC_OPTS $LEAN_OPTS"

;;

--heap)

CC_OPTS="$CC_OPTS -DSQLITE_ENABLE_MEMSYS5"

shift;

SPEEDTEST_OPTS="$SPEEDTEST_OPTS --heap $1 64"

;;

*)

CC_OPTS="$CC_OPTS $1"

;;

esac

shift

done

SPEEDTEST_OPTS="$SPEEDTEST_OPTS --size $SIZE"

echo "NAME = $NAME" | tee summary-$NAME.txt

echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" | tee -a summary-$NAME.txt

echo "CC_OPTS = $CC_OPTS" | tee -a summary-$NAME.txt

rm -f cachegrind.out.* speedtest1 speedtest1.db sqlite3.o

gcc -g -Os -Wall -I. $CC_OPTS -c sqlite3.c

size sqlite3.o | tee -a summary-$NAME.txt

if test $doExplain -eq 1; then

gcc -g -Os -Wall -I. $CC_OPTS \

-DSQLITE_ENABLE_EXPLAIN_COMMENTS \

./shell.c ./sqlite3.c -o sqlite3 -ldl -lpthread

fi

SRC=./speedtest1.c

gcc -g -Os -Wall -I. $CC_OPTS $SRC ./sqlite3.o -o speedtest1 -ldl -lpthread

ls -l speedtest1 | tee -a summary-$NAME.txt

if test $doCachegrind -eq 1; then

valgrind --tool=cachegrind ./speedtest1 speedtest1.db \

$SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt

else

./speedtest1 speedtest1.db $SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt

fi

size sqlite3.o | tee -a summary-$NAME.txt

wc sqlite3.c

if test $doCachegrind -eq 1; then

cg_anno.tcl cachegrind.out.* >cout-$NAME.txt

fi

if test $doExplain -eq 1; then

./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt

fi