webdav/sync/go/pkg/mod/modernc.org/sqlite@v1.28.0 - 志元云盘

File OriginalPic	EditTime	Size
benchmark	2024-09-01 18:06:39	20.4 KB
examples	2024-09-01 18:06:39	957 B
functest	2024-09-01 18:06:39	16.65 KB
internal	2024-09-01 18:06:39	49.8 MB
lib	2024-09-01 18:06:41	99.88 MB
libtest	2024-09-01 18:06:43	93.64 MB
speedtest1	2024-09-01 18:06:43	2.71 MB
testdata	2024-09-01 18:06:44	84.37 MB
tpch	2024-09-01 18:06:44	43.52 KB
vfs	2024-09-01 18:06:44	583.88 KB
addport.go	2024-09-01 18:06:39	1.37 KB
all_test.go	2024-09-01 18:06:39	68.81 KB
AUTHORS	2024-09-01 18:06:39	951 B
cgo_test.go	2024-09-01 18:06:39	859 B
CONTRIBUTORS	2024-09-01 18:06:39	1.23 KB
dmesg.go	2024-09-01 18:06:39	1.22 KB
doc.go	2024-09-01 18:06:39	17.17 KB
embed.db	2024-09-01 18:06:39	8 KB
embed2.db	2024-09-01 18:06:39	8 KB
generator.go	2024-09-01 18:06:39	28.24 KB
go.mod	2024-09-01 18:06:39	1.31 KB
go.sum	2024-09-01 18:06:39	6.33 KB
issue120.diff	2024-09-01 18:06:40	3.08 KB
LICENSE	2024-09-01 18:06:39	1.45 KB
Makefile	2024-09-01 18:06:39	7.93 KB
mutex.go	2024-09-01 18:06:43	502 B
nodmesg.go	2024-09-01 18:06:43	328 B
norlimit.go	2024-09-01 18:06:43	298 B
null_test.go	2024-09-01 18:06:43	478 B
README.md	2024-09-01 18:06:39	6.98 KB
rlimit.go	2024-09-01 18:06:43	434 B
rulimit.go	2024-09-01 18:06:43	499 B
sqlite.go	2024-09-01 18:06:43	65.61 KB
sqlite_go18.go	2024-09-01 18:06:43	2.39 KB
sqlite_go18_test.go	2024-09-01 18:06:43	972 B
SQLITE-LICENSE	2024-09-01 18:06:39	1.47 KB
tcl_test.go	2024-09-01 18:06:43	3.74 KB
tpch.sh	2024-09-01 18:06:44	551 B
unconvert.sh	2024-09-01 18:06:44	94 B

# sqlite

Package sqlite is a cgo-free port of SQLite. Although you could see mattn's driver (`github.com/mattn/go-sqlite3`) in go.mod file, we import it for tests only.

SQLite is an in-process implementation of a self-contained, serverless,
zero-configuration, transactional SQL database engine.

## Thanks

This project is sponsored by Schleibinger Geräte Teubert u. Greim GmbH by
allowing one of the maintainers to work on it also in office hours.

## Installation

$ go get modernc.org/sqlite

## Documentation

[godoc.org/modernc.org/sqlite](http://godoc.org/modernc.org/sqlite)

## Builders

[modern-c.appspot.com/-/builder/?importpath=modernc.org%2fsqlite](https://modern-c.appspot.com/-/builder/?importpath=modernc.org%2fsqlite)

## Speedtest1

Numbers for the pure Go version were produced by

~/src/modernc.org/sqlite/speedtest1$ go build && ./speedtest1

Numbers for the pure C version were produced by

~/src/modernc.org/sqlite/testdata/sqlite-src-3410200/test$ gcc speedtest1.c ../../sqlite-amalgamation-3410200/sqlite3.c -lpthread -ldl && ./a.out

The results are from Go version 1.20.4 and GCC version 10.2.1 on a
Linux/amd64 machine, CPU: AMD Ryzen 9 3900X 12-Core Processor × 24, 128GB
RAM. Shown are the best of 3 runs.

Go											C

-- Speedtest1 for SQLite 3.41.2 2023-03-22 11:56:21 0d1fc92f94cb6b76bffe3ec34d69	-- Speedtest1 for SQLite 3.41.2 2023-03-22 11:56:21 0d1fc92f94cb6b76bffe3ec34d69
      100 - 50000 INSERTs into table with no index......................    0.071s            100 - 50000 INSERTs into table with no index......................    0.077s
      110 - 50000 ordered INSERTS with one index/PK.....................    0.114s            110 - 50000 ordered INSERTS with one index/PK.....................    0.082s
      120 - 50000 unordered INSERTS with one index/PK...................    0.137s            120 - 50000 unordered INSERTS with one index/PK...................    0.099s
      130 - 25 SELECTS, numeric BETWEEN, unindexed......................    0.083s            130 - 25 SELECTS, numeric BETWEEN, unindexed......................    0.091s
      140 - 10 SELECTS, LIKE, unindexed.................................    0.210s            140 - 10 SELECTS, LIKE, unindexed.................................    0.120s
      142 - 10 SELECTS w/ORDER BY, unindexed............................    0.276s            142 - 10 SELECTS w/ORDER BY, unindexed............................    0.182s
      145 - 10 SELECTS w/ORDER BY and LIMIT, unindexed..................    0.183s            145 - 10 SELECTS w/ORDER BY and LIMIT, unindexed..................    0.099s
      150 - CREATE INDEX five times.....................................    0.172s            150 - CREATE INDEX five times.....................................    0.127s
      160 - 10000 SELECTS, numeric BETWEEN, indexed.....................    0.080s            160 - 10000 SELECTS, numeric BETWEEN, indexed.....................    0.078s
      161 - 10000 SELECTS, numeric BETWEEN, PK..........................    0.080s            161 - 10000 SELECTS, numeric BETWEEN, PK..........................    0.078s
      170 - 10000 SELECTS, text BETWEEN, indexed........................    0.187s            170 - 10000 SELECTS, text BETWEEN, indexed........................    0.169s
      180 - 50000 INSERTS with three indexes............................    0.196s            180 - 50000 INSERTS with three indexes............................    0.154s
      190 - DELETE and REFILL one table.................................    0.200s            190 - DELETE and REFILL one table.................................    0.155s
      200 - VACUUM......................................................    0.180s            200 - VACUUM......................................................    0.142s
      210 - ALTER TABLE ADD COLUMN, and query...........................    0.004s            210 - ALTER TABLE ADD COLUMN, and query...........................    0.005s
      230 - 10000 UPDATES, numeric BETWEEN, indexed.....................    0.093s            230 - 10000 UPDATES, numeric BETWEEN, indexed.....................    0.080s
      240 - 50000 UPDATES of individual rows............................    0.153s            240 - 50000 UPDATES of individual rows............................    0.137s
      250 - One big UPDATE of the whole 50000-row table.................    0.024s            250 - One big UPDATE of the whole 50000-row table.................    0.019s
      260 - Query added column after filling............................    0.004s            260 - Query added column after filling............................    0.005s
      270 - 10000 DELETEs, numeric BETWEEN, indexed.....................    0.278s            270 - 10000 DELETEs, numeric BETWEEN, indexed.....................    0.263s
      280 - 50000 DELETEs of individual rows............................    0.188s            280 - 50000 DELETEs of individual rows............................    0.180s
      290 - Refill two 50000-row tables using REPLACE...................    0.411s            290 - Refill two 50000-row tables using REPLACE...................    0.359s
      300 - Refill a 50000-row table using (b&1)==(a&1).................    0.175s            300 - Refill a 50000-row table using (b&1)==(a&1).................    0.151s
      310 - 10000 four-ways joins.......................................    0.427s            310 - 10000 four-ways joins.......................................    0.365s
      320 - subquery in result set......................................    0.440s            320 - subquery in result set......................................    0.521s
      400 - 70000 REPLACE ops on an IPK.................................    0.125s            400 - 70000 REPLACE ops on an IPK.................................    0.106s
      410 - 70000 SELECTS on an IPK.....................................    0.081s            410 - 70000 SELECTS on an IPK.....................................    0.078s
      500 - 70000 REPLACE on TEXT PK....................................    0.174s            500 - 70000 REPLACE on TEXT PK....................................    0.116s
      510 - 70000 SELECTS on a TEXT PK..................................    0.153s            510 - 70000 SELECTS on a TEXT PK..................................    0.117s
      520 - 70000 SELECT DISTINCT.......................................    0.083s            520 - 70000 SELECT DISTINCT.......................................    0.067s
      980 - PRAGMA integrity_check......................................    0.436s            980 - PRAGMA integrity_check......................................    0.377s
      990 - ANALYZE.....................................................    0.107s            990 - ANALYZE.....................................................    0.038s
            TOTAL.......................................................    5.525s                  TOTAL.......................................................    4.637s

This particular test executes 16.1% faster in the C version.

云盘

Home / 志元云盘 / webdav / sync / go / pkg / mod / modernc.org / [email protected]