mattn / go-sqlite3 / 666
54%

DEFAULT BRANCH: master
Ran
Jobs 16
Files 8
Run time 13min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
666

Pull #531

travis-ci

web-flow 
Let SQLite use pread/pwrite

With current settings SQLite was using lseek/read syscalls to read data, e.g.:

	20:43:17.640660 fcntl(3, F_SETLK, {l_type=F_UNLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0
	20:43:17.640683 fcntl(3, F_SETLK, {l_type=F_RDLCK, l_whence=SEEK_SET, l_start=1073741824, l_len=1}) = 0
	20:43:17.640705 fcntl(3, F_SETLK, {l_type=F_RDLCK, l_whence=SEEK_SET, l_start=1073741826, l_len=510}) = 0
	20:43:17.640725 fcntl(3, F_SETLK, {l_type=F_UNLCK, l_whence=SEEK_SET, l_start=1073741824, l_len=1}) = 0
	20:43:17.640744 stat(".../neo.sqlite-journal", 0x7ffef2c91080) = -1 ENOENT (No such file or directory)
	20:43:17.640764 lseek(3, 24, SEEK_SET)  = 24
	20:43:17.640779 read(3, "\0\0\0\33\0\0\10\235\0\0\10]\0\0\0\27", 16) = 16
	20:43:17.640795 stat(".../neo.sqlite-wal", 0x7ffef2c91080) = -1 ENOENT (No such file or directory)

but if we allow it to use pread it will be only 1 system call instead of 2 and
reading this way can also be done in parallel because there is no global to
file seeking:

	20:48:42.668466 fcntl(3, F_SETLK, {l_type=F_UNLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0
	20:48:42.668501 fcntl(3, F_SETLK, {l_type=F_RDLCK, l_whence=SEEK_SET, l_start=1073741824, l_len=1}) = 0
	20:48:42.668522 fcntl(3, F_SETLK, {l_type=F_RDLCK, l_whence=SEEK_SET, l_start=1073741826, l_len=510}) = 0
	20:48:42.668542 fcntl(3, F_SETLK, {l_type=F_UNLCK, l_whence=SEEK_SET, l_start=1073741824, l_len=1}) = 0
	20:48:42.668561 stat(".../neo.sqlite-journal", 0x7ffdbc1f22c0) = -1 ENOENT (No such file or directory)
	20:48:42.668580 pread64(3, "\0\0\0\33\0\0\10\235\0\0\10]\0\0\0\27", 16, 24) = 16
	20:48:42.668597 stat(".../neo.sqlite-wal", 0x7ffdbc1f22c0) = -1 ENOENT (No such file or directory)

(if needed this enablement can be done per OS)
Pull Request #531: Let SQLite use pread/pwrite

847 of 1234 relevant lines covered (68.64%)

1579833.97 hits per line

Uncovered Existing Lines

Lines Coverage ∆ File
7
74.75
 0.0% sqlite3.go
Jobs
ID Job ID Ran Files Coverage
1 666.1 (GOTAGS=) 7
67.28
 Travis Job 666.1
2 666.2 (GOTAGS=) 8
66.35
 Travis Job 666.2
3 666.3 (GOTAGS=) 8
66.35
 Travis Job 666.3
4 666.4 (GOTAGS=) 8
65.77
 Travis Job 666.4
5 666.5 (GOTAGS=libsqlite3) 7
67.28
 Travis Job 666.5
6 666.6 (GOTAGS=libsqlite3) 8
66.35
 Travis Job 666.6
7 666.7 (GOTAGS=libsqlite3) 8
66.35
 Travis Job 666.7
8 666.8 (GOTAGS=libsqlite3) 8
65.77
 Travis Job 666.8
9 666.9 (GOTAGS=trace) 7
67.28
 Travis Job 666.9
10 666.10 (GOTAGS=trace) 8
66.35
 Travis Job 666.10
11 666.11 (GOTAGS=trace) 8
66.35
 Travis Job 666.11
12 666.12 (GOTAGS=trace) 8
65.77
 Travis Job 666.12
13 666.13 (GOTAGS=vtable) 7
67.28
 Travis Job 666.13
14 666.14 (GOTAGS=vtable) 8
66.35
 Travis Job 666.14
15 666.15 (GOTAGS=vtable) 8
66.35
 Travis Job 666.15
16 666.16 (GOTAGS=vtable) 8
65.77
 Travis Job 666.16
Source Files on build 666
Coverage ∆ File Lines Relevant Covered Missed Hits/Line