| 1 |
#!/bin/bash |
| 2 |
# |
| 3 |
# This is a template for a script used for day-to-day size and |
| 4 |
# performance monitoring of SQLite. Typical usage: |
| 5 |
# |
| 6 |
# sh speed-check.sh trunk # Baseline measurement of trunk |
| 7 |
# sh speed-check.sh x1 # Measure some experimental change |
| 8 |
# fossil xdiff --tk jout-trunk.txt jout-x1.txt # View changes |
| 9 |
# |
| 10 |
# There are multiple output files, all with a base name given by |
| 11 |
# the first argument: |
| 12 |
# |
| 13 |
# summary-$BASE.txt # Copy of standard output |
| 14 |
# jout-$BASE.txt # cachegrind output |
| 15 |
# explain-$BASE.txt # EXPLAIN listings (only with --explain) |
| 16 |
# |
| 17 |
if test "$1" = "" |
| 18 |
then |
| 19 |
echo "Usage: $0 OUTPUTFILE [OPTIONS]" |
| 20 |
exit |
| 21 |
fi |
| 22 |
NAME=$1 |
| 23 |
shift |
| 24 |
#CC_OPTS="-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_MEMSYS5" |
| 25 |
CC_OPTS="-DSQLITE_ENABLE_MEMSYS5" |
| 26 |
CC=gcc |
| 27 |
LEAN_OPTS="-DSQLITE_THREADSAFE=0" |
| 28 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_DEFAULT_MEMSTATUS=0" |
| 29 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=1" |
| 30 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_LIKE_DOESNT_MATCH_BLOBS" |
| 31 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_MAX_EXPR_DEPTH=0" |
| 32 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_DECLTYPE" |
| 33 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_DEPRECATED" |
| 34 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_PROGRESS_CALLBACK" |
| 35 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_OMIT_SHARED_CACHE" |
| 36 |
LEAN_OPTS="$LEAN_OPTS -DSQLITE_USE_ALLOCA" |
| 37 |
BASELINE="trunk" |
| 38 |
TYPE="json" |
| 39 |
doExplain=0 |
| 40 |
doCachegrind=1 |
| 41 |
doVdbeProfile=0 |
| 42 |
doWal=1 |
| 43 |
doDiff=1 |
| 44 |
doJsonB=0 |
| 45 |
while test "$1" != ""; do |
| 46 |
case $1 in |
| 47 |
--nodiff) |
| 48 |
doDiff=0 |
| 49 |
;; |
| 50 |
--lean) |
| 51 |
CC_OPTS="$CC_OPTS $LEAN_OPTS" |
| 52 |
;; |
| 53 |
--clang) |
| 54 |
CC=clang |
| 55 |
;; |
| 56 |
--gcc7) |
| 57 |
CC=gcc-7 |
| 58 |
;; |
| 59 |
--jsonb) |
| 60 |
doJsonB=1 |
| 61 |
TYPE="jsonb" |
| 62 |
;; |
| 63 |
-*) |
| 64 |
CC_OPTS="$CC_OPTS $1" |
| 65 |
;; |
| 66 |
*) |
| 67 |
BASELINE=$1 |
| 68 |
;; |
| 69 |
esac |
| 70 |
shift |
| 71 |
done |
| 72 |
echo "NAME = $NAME" | tee summary-$NAME.txt |
| 73 |
echo "CC_OPTS = $CC_OPTS" | tee -a summary-$NAME.txt |
| 74 |
rm -f cachegrind.out.* jsonshell |
| 75 |
$CC -g -Os -Wall -I. $CC_OPTS ./shell.c ./sqlite3.c -o jsonshell -lm -ldl -lpthread |
| 76 |
ls -l jsonshell | tee -a summary-$NAME.txt |
| 77 |
home=`echo $0 | sed -e 's,/[^/]*$,,'` |
| 78 |
DB=$TYPE''100mb.db |
| 79 |
echo ./jsonshell $DB "<$home/$TYPE-q1.txt" |
| 80 |
valgrind --tool=cachegrind ./jsonshell json100mb_b.db <$home/$TYPE-q1.txt \ |
| 81 |
2>&1 | tee -a summary-$NAME.txt |
| 82 |
cg_anno.tcl cachegrind.out.* >$TYPE-$NAME.txt |
| 83 |
echo '*****************************************************' >>$TYPE-$NAME.txt |
| 84 |
sed 's/^[0-9=-]\{9\}/==00000==/' summary-$NAME.txt >>$TYPE-$NAME.txt |
| 85 |
if test "$NAME" != "$BASELINE" -a $doDiff -ne 0; then |
| 86 |
fossil xdiff --tk -c 20 $TYPE-$BASELINE.txt $TYPE-$NAME.txt |
| 87 |
fi |