OLD | NEW |
(Empty) | |
| 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 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 |
| 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 # cout-$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 SPEEDTEST_OPTS="--shrink-memory --reprepare --stats --heap 10000000 64" |
| 28 SIZE=5 |
| 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_BLOB" |
| 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" |
| 39 doExplain=0 |
| 40 doCachegrind=1 |
| 41 while test "$1" != ""; do |
| 42 case $1 in |
| 43 --reprepare) |
| 44 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 45 ;; |
| 46 --autovacuum) |
| 47 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 48 ;; |
| 49 --utf16be) |
| 50 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 51 ;; |
| 52 --stats) |
| 53 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 54 ;; |
| 55 --without-rowid) |
| 56 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 57 ;; |
| 58 --nomemstat) |
| 59 SPEEDTEST_OPTS="$SPEEDTEST_OPTS $1" |
| 60 ;; |
| 61 --temp) |
| 62 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --temp 6" |
| 63 ;; |
| 64 --wal) |
| 65 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --journal wal" |
| 66 ;; |
| 67 --size) |
| 68 shift; SIZE=$1 |
| 69 ;; |
| 70 --cachesize) |
| 71 shift; SPEEDTEST_OPTS="$SPEEDTEST_OPTS --cachesize $1" |
| 72 ;; |
| 73 --explain) |
| 74 doExplain=1 |
| 75 ;; |
| 76 --vdbeprofile) |
| 77 rm -f vdbe_profile.out |
| 78 CC_OPTS="$CC_OPTS -DVDBE_PROFILE" |
| 79 doCachegrind=0 |
| 80 ;; |
| 81 --lean) |
| 82 CC_OPTS="$CC_OPTS $LEAN_OPTS" |
| 83 ;; |
| 84 --clang) |
| 85 CC=clang |
| 86 ;; |
| 87 --heap) |
| 88 CC_OPTS="$CC_OPTS -DSQLITE_ENABLE_MEMSYS5" |
| 89 shift; |
| 90 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --heap $1 64" |
| 91 ;; |
| 92 --lookaside) |
| 93 shift; |
| 94 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --lookaside $1 $2" |
| 95 shift; |
| 96 ;; |
| 97 --repeat) |
| 98 CC_OPTS="$CC_OPTS -DSQLITE_ENABLE_RCACHE" |
| 99 shift; |
| 100 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --repeat $1" |
| 101 ;; |
| 102 --mmap) |
| 103 shift; |
| 104 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --mmap $1" |
| 105 ;; |
| 106 --rtree) |
| 107 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --testset rtree" |
| 108 CC_OPTS="$CC_OPTS -DSQLITE_ENABLE_RTREE" |
| 109 ;; |
| 110 *) |
| 111 CC_OPTS="$CC_OPTS $1" |
| 112 ;; |
| 113 esac |
| 114 shift |
| 115 done |
| 116 SPEEDTEST_OPTS="$SPEEDTEST_OPTS --size $SIZE" |
| 117 echo "NAME = $NAME" | tee summary-$NAME.txt |
| 118 echo "SPEEDTEST_OPTS = $SPEEDTEST_OPTS" | tee -a summary-$NAME.txt |
| 119 echo "CC_OPTS = $CC_OPTS" | tee -a summary-$NAME.txt |
| 120 rm -f cachegrind.out.* speedtest1 speedtest1.db sqlite3.o |
| 121 $CC -g -Os -Wall -I. $CC_OPTS -c sqlite3.c |
| 122 size sqlite3.o | tee -a summary-$NAME.txt |
| 123 if test $doExplain -eq 1; then |
| 124 $CC -g -Os -Wall -I. $CC_OPTS \ |
| 125 -DSQLITE_ENABLE_EXPLAIN_COMMENTS \ |
| 126 ./shell.c ./sqlite3.c -o sqlite3 -ldl -lpthread |
| 127 fi |
| 128 SRC=./speedtest1.c |
| 129 $CC -g -Os -Wall -I. $CC_OPTS $SRC ./sqlite3.o -o speedtest1 -ldl -lpthread |
| 130 ls -l speedtest1 | tee -a summary-$NAME.txt |
| 131 if test $doCachegrind -eq 1; then |
| 132 valgrind --tool=cachegrind ./speedtest1 speedtest1.db \ |
| 133 $SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt |
| 134 else |
| 135 ./speedtest1 speedtest1.db $SPEEDTEST_OPTS 2>&1 | tee -a summary-$NAME.txt |
| 136 fi |
| 137 size sqlite3.o | tee -a summary-$NAME.txt |
| 138 wc sqlite3.c |
| 139 if test $doCachegrind -eq 1; then |
| 140 cg_anno.tcl cachegrind.out.* >cout-$NAME.txt |
| 141 fi |
| 142 if test $doExplain -eq 1; then |
| 143 ./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt |
| 144 fi |
| 145 if test "$NAME" != "trunk"; then |
| 146 fossil test-diff --tk cout-trunk.txt cout-$NAME.txt |
| 147 fi |
OLD | NEW |