3 # This is a template for a script used for day-to-day size and
4 # performance monitoring of SQLite. Typical usage:
6 # sh run-speed-test.sh trunk # Baseline measurement of trunk
7 # sh run-speed-test.sh x1 # Measure some experimental change
8 # fossil test-diff --tk cout-trunk.txt cout-x1.txt # View chanages
10 # There are multiple output files, all with a base name given by
13 # summary-$BASE.txt # Copy of standard output
14 # cout-$BASE.txt # cachegrind output
15 # explain-$BASE.txt # EXPLAIN listings (only with --explain)
19 echo "Usage: $0 OUTPUTFILE [OPTIONS]"
24 #CC_OPTS="-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_MEMSYS5"
25 CC_OPTS
="-DSQLITE_ENABLE_MEMSYS5"
27 SPEEDTEST_OPTS
="--shrink-memory --reprepare --stats --heap 10000000 64"
29 LEAN_OPTS
="-DSQLITE_THREADSAFE=0"
30 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_DEFAULT_MEMSTATUS=0"
31 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=1"
32 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_LIKE_DOESNT_MATCH_BLOBS"
33 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_MAX_EXPR_DEPTH=0"
34 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_OMIT_DECLTYPE"
35 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_OMIT_DEPRECATED"
36 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_OMIT_PROGRESS_CALLBACK"
37 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_OMIT_SHARED_CACHE"
38 LEAN_OPTS
="$LEAN_OPTS -DSQLITE_USE_ALLOCA"
42 while test "$1" != ""; do
45 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
48 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
51 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
54 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
57 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
60 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
63 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --temp 6"
66 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --journal wal"
72 shift; SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --cachesize $1"
78 rm -f vdbe_profile.out
79 CC_OPTS
="$CC_OPTS -DVDBE_PROFILE"
83 CC_OPTS
="$CC_OPTS $LEAN_OPTS"
89 CC
=/home
/drh
/intel
/bin
/icc
95 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_MEMSYS5"
97 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --heap $1 64"
101 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --lookaside $1 $2"
105 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_RCACHE"
107 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --repeat $1"
111 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --mmap $1"
114 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset rtree"
115 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_RTREE"
118 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset orm"
121 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset cte"
124 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset fp"
127 CC_OPTS
="$CC_OPTS $1"
135 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --size $SIZE"
136 echo "NAME = $NAME" |
tee summary-
$NAME.txt
137 echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" |
tee -a summary-
$NAME.txt
138 echo "CC_OPTS = $CC_OPTS" |
tee -a summary-
$NAME.txt
139 rm -f cachegrind.out.
* speedtest1 speedtest1.db sqlite3.o
140 $CC -g -Os -Wall -I.
$CC_OPTS -c sqlite3.c
141 size sqlite3.o |
tee -a summary-
$NAME.txt
142 if test $doExplain -eq 1; then
143 $CC -g -Os -Wall -I.
$CC_OPTS \
144 -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
145 .
/shell.c .
/sqlite3.c
-o sqlite3
-ldl -lpthread
148 $CC -g -Os -Wall -I.
$CC_OPTS $SRC .
/sqlite3.o
-o speedtest1
-ldl -lpthread
149 ls -l speedtest1 |
tee -a summary-
$NAME.txt
150 if test $doCachegrind -eq 1; then
151 valgrind
--tool=cachegrind .
/speedtest1 speedtest1.db \
152 $SPEEDTEST_OPTS 2>&1 |
tee -a summary-
$NAME.txt
154 .
/speedtest1 speedtest1.db
$SPEEDTEST_OPTS 2>&1 |
tee -a summary-
$NAME.txt
156 size sqlite3.o |
tee -a summary-
$NAME.txt
158 if test $doCachegrind -eq 1; then
159 cg_anno.tcl cachegrind.out.
* >cout-
$NAME.txt
160 echo '*****************************************************' >>cout-
$NAME.txt
161 sed 's/^[0-9=-]\{9\}/==00000==/' summary-
$NAME.txt
>>cout-
$NAME.txt
163 if test $doExplain -eq 1; then
164 .
/speedtest1
--explain $SPEEDTEST_OPTS | .
/sqlite3
>explain-
$NAME.txt
166 if test "$NAME" != "$BASELINE"; then
167 fossil test-diff
--tk -c 20 cout-
$BASELINE.txt cout-
$NAME.txt