OLD | NEW |
1 #!/bin/bash | 1 #!/bin/bash |
2 # | 2 # |
3 # This is a template for a script used for day-to-day size and | 3 # This is a template for a script used for day-to-day size and |
4 # performance monitoring of SQLite. Typical usage: | 4 # performance monitoring of SQLite. Typical usage: |
5 # | 5 # |
6 # sh run-speed-test.sh trunk # Baseline measurement of trunk | 6 # sh run-speed-test.sh trunk # Baseline measurement of trunk |
7 # sh run-speed-test.sh x1 # Measure some experimental change | 7 # sh run-speed-test.sh x1 # Measure some experimental change |
8 # fossil test-diff --tk cout-trunk.txt cout-x1.txt # View chanages | 8 # fossil test-diff --tk cout-trunk.txt cout-x1.txt # View chanages |
9 # | 9 # |
10 # There are multiple output files, all with a base name given by | 10 # There are multiple output files, all with a base name given by |
11 # the first argument: | 11 # the first argument: |
12 # | 12 # |
13 # summary-$BASE.txt # Copy of standard output | 13 # summary-$BASE.txt # Copy of standard output |
14 # cout-$BASE.txt # cachegrind output | 14 # cout-$BASE.txt # cachegrind output |
15 # explain-$BASE.txt # EXPLAIN listings | 15 # explain-$BASE.txt # EXPLAIN listings (only with --explain) |
16 # | 16 # |
17 if test "$1" = "" | 17 if test "$1" = "" |
18 then | 18 then |
19 echo "Usage: $0 OUTPUTFILE [OPTIONS]" | 19 echo "Usage: $0 OUTPUTFILE [OPTIONS]" |
20 exit | 20 exit |
21 fi | 21 fi |
22 NAME=$1 | 22 NAME=$1 |
23 shift | 23 shift |
24 CC_OPTS="-DSQLITE_ENABLE_RTREE" | 24 CC_OPTS="-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_MEMSYS5" |
25 SPEEDTEST_OPTS="--shrink-memory --reprepare" | 25 SPEEDTEST_OPTS="--shrink-memory --reprepare --heap 10000000 64" |
26 SIZE=5 | 26 SIZE=5 |
| 27 doExplain=0 |
27 while test "$1" != ""; do | 28 while test "$1" != ""; do |
28 case $1 in | 29 case $1 in |
29 --reprepare) | 30 --reprepare) |
30 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" | 31 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
31 ;; | 32 ;; |
32 --autovacuum) | 33 --autovacuum) |
33 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" | 34 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
34 ;; | 35 ;; |
35 --utf16be) | 36 --utf16be) |
36 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" | 37 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
37 ;; | 38 ;; |
| 39 --stats) |
| 40 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 41 ;; |
38 --without-rowid) | 42 --without-rowid) |
39 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" | 43 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
40 ;; | 44 ;; |
| 45 --nomemstat) |
| 46 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 47 ;; |
| 48 --wal) |
| 49 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --journal wal" |
| 50 ;; |
41 --size) | 51 --size) |
42 shift; SIZE=$1 | 52 shift; SIZE=$1 |
43 ;; | 53 ;; |
| 54 --explain) |
| 55 doExplain=1 |
| 56 ;; |
| 57 --heap) |
| 58 CC_OPTS="$CC_OPTS -DSQLITE_ENABLE_MEMSYS5" |
| 59 shift; |
| 60 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --heap $1 64" |
| 61 ;; |
44 *) | 62 *) |
45 CC_OPTS="$CC_OPTS $1" | 63 CC_OPTS="$CC_OPTS $1" |
46 ;; | 64 ;; |
47 esac | 65 esac |
48 shift | 66 shift |
49 done | 67 done |
50 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --size $SIZE" | 68 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --size $SIZE" |
51 echo "NAME = $NAME" | tee summary-$NAME.txt | 69 echo "NAME = $NAME" | tee summary-$NAME.txt |
52 echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" | tee -a summary-$NAME.txt | 70 echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" | tee -a summary-$NAME.txt |
53 echo "CC_OPTS = $CC_OPTS" | tee -a summary-$NAME.txt | 71 echo "CC_OPTS = $CC_OPTS" | tee -a summary-$NAME.txt |
54 rm -f cachegrind.out.* speedtest1 speedtest1.db sqlite3.o | 72 rm -f cachegrind.out.* speedtest1 speedtest1.db sqlite3.o |
55 gcc -g -Os -Wall -I. $CC_OPTS -c sqlite3.c | 73 gcc -g -Os -Wall -I. $CC_OPTS -c sqlite3.c |
56 size sqlite3.o | tee -a summary-$NAME.txt | 74 size sqlite3.o | tee -a summary-$NAME.txt |
57 gcc -g -Os -Wall -I. $CC_OPTS \ | 75 if test $doExplain -eq 1; then |
58 -DSQLITE_ENABLE_EXPLAIN_COMMENTS \ | 76 gcc -g -Os -Wall -I. $CC_OPTS \ |
59 ./shell.c ./sqlite3.c -o sqlite3 -ldl -lpthread | 77 -DSQLITE_ENABLE_EXPLAIN_COMMENTS \ |
| 78 ./shell.c ./sqlite3.c -o sqlite3 -ldl -lpthread |
| 79 fi |
60 SRC=./speedtest1.c | 80 SRC=./speedtest1.c |
61 gcc -g -Os -Wall -I. $CC_OPTS $SRC ./sqlite3.o -o speedtest1 -ldl -lpthread | 81 gcc -g -Os -Wall -I. $CC_OPTS $SRC ./sqlite3.o -o speedtest1 -ldl -lpthread |
62 ls -l speedtest1 | tee -a summary-$NAME.txt | 82 ls -l speedtest1 | tee -a summary-$NAME.txt |
63 valgrind --tool=cachegrind ./speedtest1 speedtest1.db \ | 83 valgrind --tool=cachegrind ./speedtest1 speedtest1.db \ |
64 $SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt | 84 $SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt |
65 size sqlite3.o | tee -a summary-$NAME.txt | 85 size sqlite3.o | tee -a summary-$NAME.txt |
66 wc sqlite3.c | 86 wc sqlite3.c |
67 cg_anno.tcl cachegrind.out.* >cout-$NAME.txt | 87 cg_anno.tcl cachegrind.out.* >cout-$NAME.txt |
68 ./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt | 88 if test $doExplain -eq 1; then |
| 89 ./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt |
| 90 fi |
OLD | NEW |