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"
44 while test "$1" != ""; do
47 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
50 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
53 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
56 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
59 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
62 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS $1"
65 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --temp 6"
77 shift; SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --cachesize $1"
83 rm -f vdbe_profile.out
84 CC_OPTS
="$CC_OPTS -DVDBE_PROFILE"
89 CC_OPTS
="$CC_OPTS $LEAN_OPTS"
95 CC
=/home
/drh
/intel
/bin
/icc
101 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_MEMSYS5"
103 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --heap $1 64"
107 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --lookaside $1 $2"
111 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_RCACHE"
113 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --repeat $1"
117 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --mmap $1"
120 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset rtree"
121 CC_OPTS
="$CC_OPTS -DSQLITE_ENABLE_RTREE"
124 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset orm"
127 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset cte"
130 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --testset fp"
133 CC_OPTS
="$CC_OPTS $1"
141 if test $doWal -eq 1; then
142 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --journal wal"
144 SPEEDTEST_OPTS
="$SPEEDTEST_OPTS --size $SIZE"
145 echo "NAME = $NAME" |
tee summary-
$NAME.txt
146 echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" |
tee -a summary-
$NAME.txt
147 echo "CC_OPTS = $CC_OPTS" |
tee -a summary-
$NAME.txt
148 rm -f cachegrind.out.
* speedtest1 speedtest1.db sqlite3.o
149 if test $doVdbeProfile -eq 1; then
150 rm -f vdbe_profile.out
152 $CC -g -Os -Wall -I.
$CC_OPTS -c sqlite3.c
153 size sqlite3.o |
tee -a summary-
$NAME.txt
154 if test $doExplain -eq 1; then
155 $CC -g -Os -Wall -I.
$CC_OPTS \
156 -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
157 .
/shell.c .
/sqlite3.c
-o sqlite3
-ldl -lpthread
160 $CC -g -Os -Wall -I.
$CC_OPTS $SRC .
/sqlite3.o
-o speedtest1
-ldl -lpthread
161 ls -l speedtest1 |
tee -a summary-
$NAME.txt
162 if test $doCachegrind -eq 1; then
163 valgrind
--tool=cachegrind .
/speedtest1 speedtest1.db \
164 $SPEEDTEST_OPTS 2>&1 |
tee -a summary-
$NAME.txt
166 .
/speedtest1 speedtest1.db
$SPEEDTEST_OPTS 2>&1 |
tee -a summary-
$NAME.txt
168 size sqlite3.o |
tee -a summary-
$NAME.txt
170 if test $doCachegrind -eq 1; then
171 cg_anno.tcl cachegrind.out.
* >cout-
$NAME.txt
172 echo '*****************************************************' >>cout-
$NAME.txt
173 sed 's/^[0-9=-]\{9\}/==00000==/' summary-
$NAME.txt
>>cout-
$NAME.txt
175 if test $doExplain -eq 1; then
176 .
/speedtest1
--explain $SPEEDTEST_OPTS | .
/sqlite3
>explain-
$NAME.txt
178 if test $doVdbeProfile -eq 1; then
179 tclsh ..
/sqlite
/tool
/vdbe_profile.tcl
>vdbeprofile-
$NAME.txt
180 open vdbeprofile-
$NAME.txt
182 if test "$NAME" != "$BASELINE" -a $doVdbeProfile -ne 1; then
183 fossil test-diff
--tk -c 20 cout-
$BASELINE.txt cout-
$NAME.txt