mirror of
https://gitlab.com/cznic/sqlite.git
synced 2025-07-22 00:29:16 +00:00
goos: linux goarch: amd64 pkg: modernc.org/sqlite benchmark old ns/op new ns/op delta BenchmarkInsertComparative/sqliteInMemory1e2-24 429571 377501 -12.12% BenchmarkInsertComparative/sqliteInMemory1e1-24 48237 42821 -11.23% BenchmarkInsertComparative/sqliteOnDisk1e6-24 4154225001 3700442279 -10.92% BenchmarkInsertComparative/sqliteInMemory1e3-24 4159909 3706782 -10.89% BenchmarkInsertComparative/sqliteInMemory1e5-24 413908251 371288884 -10.30% BenchmarkInsertComparative/sqliteInMemory1e6-24 4115347177 3716848025 -9.68% BenchmarkInsertComparative/sqliteInMemory1e4-24 40789173 36868407 -9.61% BenchmarkInsertComparative/sqliteOnDisk1e4-24 42562798 38656452 -9.18% BenchmarkInsertComparative/sqliteOnDisk1e5-24 402785172 369788052 -8.19% BenchmarkInsertComparative/sqliteOnDisk1e3-24 5458279 5074514 -7.03% BenchmarkReading1/sqliteOnDisk1e5-24 43129144 41231015 -4.40% BenchmarkInsertComparative/sqliteOnDisk1e2-24 1941170 1862031 -4.08% BenchmarkReading1/sqliteInMemory1e2-24 37453 36098 -3.62% BenchmarkReading1/sqliteInMemory1e6-24 425087394 412138650 -3.05% BenchmarkReading1/sqliteInMemory1e3-24 433789 420847 -2.98% BenchmarkReading1/sqliteInMemory1e5-24 43580631 44920215 +3.07% BenchmarkInsertComparative/sqliteOnDisk1e1-24 1424724 1383383 -2.90% BenchmarkReading1/sqliteOnDisk1e3-24 420967 408792 -2.89% BenchmarkReading1/sqliteInMemory1e4-24 4141184 4246119 +2.53% BenchmarkReading1/sqliteOnDisk1e6-24 427200030 416698349 -2.46% BenchmarkReading1/sqliteInMemory1e1-24 4155 4214 +1.42% BenchmarkReading1/sqliteOnDisk1e1-24 4244 4293 +1.15% BenchmarkReading1/sqliteOnDisk1e4-24 4191184 4148692 -1.01% BenchmarkReading1/sqliteOnDisk1e2-24 35719 35661 -0.16% benchmark old MB/s new MB/s speedup BenchmarkInsertComparative/sqliteInMemory1e2-24 232790.51 264899.97 1.14x BenchmarkInsertComparative/sqliteInMemory1e1-24 207307.71 233530.55 1.13x BenchmarkInsertComparative/sqliteOnDisk1e6-24 240718.79 270237.97 1.12x BenchmarkInsertComparative/sqliteInMemory1e3-24 240389.86 269775.81 1.12x BenchmarkInsertComparative/sqliteInMemory1e5-24 241599.44 269332.06 1.11x BenchmarkInsertComparative/sqliteInMemory1e6-24 242992.86 269045.17 1.11x BenchmarkInsertComparative/sqliteInMemory1e4-24 245163.10 271234.94 1.11x BenchmarkInsertComparative/sqliteOnDisk1e4-24 234946.96 258689.03 1.10x BenchmarkInsertComparative/sqliteOnDisk1e5-24 248271.30 270425.18 1.09x BenchmarkInsertComparative/sqliteOnDisk1e3-24 183207.93 197063.22 1.08x BenchmarkReading1/sqliteOnDisk1e5-24 2318617.77 2425358.70 1.05x BenchmarkInsertComparative/sqliteOnDisk1e2-24 51515.33 53704.79 1.04x BenchmarkReading1/sqliteInMemory1e2-24 2669989.49 2770256.42 1.04x BenchmarkReading1/sqliteInMemory1e6-24 2352457.44 2426367.92 1.03x BenchmarkReading1/sqliteInMemory1e3-24 2305266.63 2376161.60 1.03x BenchmarkReading1/sqliteInMemory1e5-24 2294597.33 2226169.21 0.97x BenchmarkInsertComparative/sqliteOnDisk1e1-24 7018.90 7228.65 1.03x BenchmarkReading1/sqliteOnDisk1e3-24 2375484.11 2446234.47 1.03x BenchmarkReading1/sqliteInMemory1e4-24 2414768.40 2355092.06 0.98x BenchmarkReading1/sqliteOnDisk1e6-24 2340823.81 2399817.53 1.03x BenchmarkReading1/sqliteInMemory1e1-24 2406780.42 2372802.98 0.99x BenchmarkReading1/sqliteOnDisk1e1-24 2356337.86 2329103.03 0.99x BenchmarkReading1/sqliteOnDisk1e4-24 2385960.79 2410398.31 1.01x BenchmarkReading1/sqliteOnDisk1e2-24 2799619.97 2804187.40 1.00x benchmark old allocs new allocs delta BenchmarkInsertComparative/sqliteInMemory1e2-24 604 504 -16.56% BenchmarkInsertComparative/sqliteOnDisk1e2-24 616 516 -16.23% BenchmarkInsertComparative/sqliteInMemory1e1-24 64 54 -15.62% BenchmarkInsertComparative/sqliteInMemory1e3-24 6748 5748 -14.82% BenchmarkInsertComparative/sqliteOnDisk1e3-24 6760 5760 -14.79% BenchmarkInsertComparative/sqliteInMemory1e4-24 69748 59748 -14.34% BenchmarkInsertComparative/sqliteOnDisk1e4-24 69760 59760 -14.33% BenchmarkInsertComparative/sqliteInMemory1e5-24 699748 599748 -14.29% BenchmarkInsertComparative/sqliteOnDisk1e5-24 699760 599760 -14.29% BenchmarkInsertComparative/sqliteOnDisk1e6-24 6999761 5999760 -14.29% BenchmarkInsertComparative/sqliteInMemory1e6-24 6999748 5999749 -14.29% BenchmarkInsertComparative/sqliteOnDisk1e1-24 76 66 -13.16% benchmark old bytes new bytes delta BenchmarkInsertComparative/sqliteInMemory1e1-24 1360 1200 -11.76% BenchmarkInsertComparative/sqliteInMemory1e2-24 12880 11376 -11.68% BenchmarkInsertComparative/sqliteOnDisk1e2-24 12960 11472 -11.48% BenchmarkInsertComparative/sqliteOnDisk1e1-24 1440 1296 -10.00% BenchmarkInsertComparative/sqliteInMemory1e3-24 134032 124224 -7.32% BenchmarkInsertComparative/sqliteOnDisk1e3-24 134113 124336 -7.29% BenchmarkInsertComparative/sqliteInMemory1e4-24 1358038 1276229 -6.02% BenchmarkInsertComparative/sqliteOnDisk1e4-24 1358122 1276343 -6.02% BenchmarkInsertComparative/sqliteInMemory1e5-24 13598144 12796272 -5.90% BenchmarkInsertComparative/sqliteOnDisk1e5-24 13598197 12796405 -5.90% BenchmarkInsertComparative/sqliteOnDisk1e6-24 135998816 127996608 -5.88% BenchmarkInsertComparative/sqliteInMemory1e6-24 135998544 127996640 -5.88% BenchmarkReading1/sqliteInMemory1e4-24 156432 156440 +0.01% BenchmarkReading1/sqliteOnDisk1e4-24 156433 156432 -0.00% BenchmarkReading1/sqliteInMemory1e5-24 1596439 1596434 -0.00% BenchmarkReading1/sqliteOnDisk1e5-24 1596439 1596435 -0.00% BenchmarkReading1/sqliteInMemory1e6-24 15996522 15996490 -0.00% BenchmarkReading1/sqliteOnDisk1e6-24 15996485 15996506 +0.00%
168 lines
5.5 KiB
Makefile
168 lines
5.5 KiB
Makefile
# Copyright 2017 The Sqlite Authors. All rights reserved.
|
|
# Use of this source code is governed by a BSD-style
|
|
# license that can be found in the LICENSE file.
|
|
|
|
.PHONY: all clean cover cpu editor internalError later mem nuke todo edit tcl extraquick full
|
|
|
|
grep=--include=*.go --include=*.l --include=*.y --include=*.yy
|
|
ngrep='TODOOK\|internal\/vfs\|internal\/bin\|internal\/mptest\|.*stringer.*\.go'
|
|
host=$(shell go env GOOS)-$(shell go env GOARCH)
|
|
testlog=testdata/testlog-$(shell echo $$GOOS)-$(shell echo $$GOARCH)$(shell echo $$SQLITE_TEST_SUFFIX)
|
|
|
|
all: editor
|
|
date
|
|
go version 2>&1 | tee log
|
|
./unconvert.sh
|
|
gofmt -l -s -w *.go
|
|
go test -i
|
|
go test -v 2>&1 -timeout 24h | tee -a log
|
|
go run speedtest1/main_$(shell go env GOOS)_$(shell go env GOARCH).go
|
|
GOOS=linux GOARCH=386 go build -v ./...
|
|
GOOS=linux GOARCH=386 go build -v ./...
|
|
GOOS=linux GOARCH=amd64 go build -v ./...
|
|
GOOS=linux GOARCH=amd64 go build -v ./...
|
|
GOOS=linux GOARCH=arm go build -v ./...
|
|
GOOS=linux GOARCH=arm64 go build -v ./...
|
|
GOOS=windows GOARCH=386 go build -v ./...
|
|
GOOS=windows GOARCH=amd64 go build -v ./...
|
|
golint 2>&1 | grep -v $(ngrep) || true
|
|
misspell *.go
|
|
staticcheck || true
|
|
maligned || true
|
|
git diff --unified=0 testdata *.golden
|
|
grep -n --color=always 'FAIL\|PASS' log
|
|
go version
|
|
date 2>&1 | tee -a log
|
|
|
|
darwin_amd64:
|
|
TARGET_GOOS=darwin TARGET_GOARCH=amd64 go generate 2>&1 | tee /tmp/log-generate-sqlite-darwin-amd64
|
|
GOOS=darwin GOARCH=amd64 go build -v ./...
|
|
|
|
linux_amd64:
|
|
TARGET_GOOS=linux TARGET_GOARCH=amd64 go generate 2>&1 | tee /tmp/log-generate-sqlite-linux-amd64
|
|
GOOS=linux GOARCH=amd64 go build -v ./...
|
|
|
|
linux_386:
|
|
CCGO_CPP=i686-linux-gnu-cpp TARGET_GOARCH=386 TARGET_GOOS=linux go generate 2>&1 | tee /tmp/log-generate-sqlite-linux-386
|
|
GOOS=linux GOARCH=386 go build -v ./...
|
|
|
|
linux_arm:
|
|
CCGO_CPP=arm-linux-gnueabi-cpp-8 TARGET_GOARCH=arm TARGET_GOOS=linux go generate 2>&1 | tee /tmp/log-generate-sqlite-linux-arm
|
|
GOOS=linux GOARCH=arm go build -v ./...
|
|
|
|
linux_arm64:
|
|
CCGO_CPP=aarch64-linux-gnu-cpp-8 TARGET_GOARCH=arm64 TARGET_GOOS=linux go generate 2>&1 | tee /tmp/log-generate-sqlite-linux-arm64
|
|
GOOS=linux GOARCH=arm64 go build -v ./...
|
|
|
|
windows_amd64:
|
|
CCGO_CPP=x86_64-w64-mingw32-cpp TARGET_GOOS=windows TARGET_GOARCH=amd64 go generate 2>&1 | tee /tmp/log-generate-sqlite-windows-amd64
|
|
GOOS=windows GOARCH=amd64 go build -v ./...
|
|
|
|
windows_386:
|
|
CCGO_CPP=i686-w64-mingw32-cpp TARGET_GOOS=windows TARGET_GOARCH=386 go generate 2>&1 | tee /tmp/log-generate-sqlite-windows-386
|
|
GOOS=windows GOARCH=386 go build -v ./...
|
|
|
|
all_targets: linux_amd64 linux_386 linux_arm linux_arm64 windows_amd64 windows_386
|
|
gofmt -l -s -w .
|
|
echo done
|
|
|
|
test:
|
|
go version | tee $(testlog)
|
|
uname -a | tee -a $(testlog)
|
|
go test -v -timeout 24h | tee -a $(testlog)
|
|
grep -ni fail $(testlog) | tee -a $(testlog) || true
|
|
LC_ALL=C date | tee -a $(testlog)
|
|
grep -ni --color=always fail $(testlog) || true
|
|
|
|
test_darwin_amd64:
|
|
GOOS=darwin GOARCH=amd64 make test
|
|
|
|
test_linux_amd64:
|
|
GOOS=linux GOARCH=amd64 make test
|
|
|
|
test_linux_386:
|
|
GOOS=linux GOARCH=386 make test
|
|
|
|
test_linux_386_hosted:
|
|
GOOS=linux GOARCH=386 SQLITE_TEST_SUFFIX=-hosted-$(host) make test
|
|
|
|
test_linux_arm:
|
|
GOOS=linux GOARCH=arm make test
|
|
|
|
test_linux_arm64:
|
|
GOOS=linux GOARCH=arm64 make test
|
|
|
|
extraquick:
|
|
go test -timeout 24h -v -run Tcl -suite extraquick -maxerror 1 2>&1 | tee log-extraquick
|
|
date
|
|
|
|
full:
|
|
go test -timeout 24h -v -run Tcl -suite full 2>&1 | tee log-full
|
|
date
|
|
|
|
clean:
|
|
go clean
|
|
rm -f *~ *.test *.out test.db* tt4-test*.db* test_sv.* testdb-*
|
|
|
|
cover:
|
|
t=$(shell tempfile) ; go test -coverprofile $$t && go tool cover -html $$t && unlink $$t
|
|
|
|
cpu: clean
|
|
go test -run @ -bench . -cpuprofile cpu.out
|
|
go tool pprof -lines *.test cpu.out
|
|
|
|
edit:
|
|
@touch log
|
|
@if [ -f "Session.vim" ]; then gvim -S & else gvim -p Makefile *.go & fi
|
|
|
|
editor:
|
|
gofmt -l -s -w *.go
|
|
GO111MODULE=off go install -v ./...
|
|
|
|
internalError:
|
|
egrep -ho '"internal error.*"' *.go | sort | cat -n
|
|
|
|
later:
|
|
@grep -n $(grep) LATER * || true
|
|
@grep -n $(grep) MAYBE * || true
|
|
|
|
mem: clean
|
|
go test -run @ -bench . -memprofile mem.out -memprofilerate 1 -timeout 24h
|
|
go tool pprof -lines -web -alloc_space *.test mem.out
|
|
|
|
memgrind:
|
|
go test -v -timeout 24h -tags=libc.memgrind,cgobench -run Test[^T][^c][^l] -bench . -recs_per_sec_as_mbps 2>&1 | tee log-memgrind
|
|
|
|
regression_base_release:
|
|
GO111MODULE=on go test -v -timeout 24h -tags=cgobench -run @ -bench '(Reading1|InsertComparative)/sqlite[^3]' -recs_per_sec_as_mbps 2>&1 | tee log-regression-base
|
|
|
|
regression_base_master:
|
|
GO111MODULE=off go test -v -timeout 24h -tags=cgobench -run @ -bench '(Reading1|InsertComparative)/sqlite[^3]' -recs_per_sec_as_mbps 2>&1 | tee log-regression-base
|
|
|
|
regression_check:
|
|
GO111MODULE=off go test -v -timeout 24h -tags=cgobench -run @ -bench '(Reading1|InsertComparative)/sqlite[^3]' -recs_per_sec_as_mbps 2>&1 | tee log-regression
|
|
benchcmp -changed -mag log-regression-base log-regression
|
|
|
|
nuke: clean
|
|
go clean -i
|
|
|
|
todo:
|
|
@grep -nr $(grep) ^[[:space:]]*_[[:space:]]*=[[:space:]][[:alpha:]][[:alnum:]]* * | grep -v $(ngrep) || true
|
|
@grep -nr $(grep) TODO * | grep -v $(ngrep) || true
|
|
@grep -nr $(grep) BUG * | grep -v $(ngrep) || true
|
|
@grep -nr $(grep) [^[:alpha:]]println * | grep -v $(ngrep) || true
|
|
|
|
tcl:
|
|
cp log log-0
|
|
go test -run Tcl$$ 2>&1 -timeout 24h -trc | tee log
|
|
grep -c '\.\.\. \?Ok' log || true
|
|
grep -c '^!' log || true
|
|
# grep -c 'Error:' log || true
|
|
|
|
tclshort:
|
|
cp log log-0
|
|
go test -run Tcl$$ -short 2>&1 -timeout 24h -trc | tee log
|
|
grep -c '\.\.\. \?Ok' log || true
|
|
grep -c '^!' log || true
|
|
# grep -c 'Error:' log || true
|