564
95%
master: 92%

Ran 23 Jan 2017 08:24PM UTC

Jobs 13

Files 73

Run time 12min

Badge

Embed ▾

pending completion

Build # 564

Build Type

push

travis-ci

Committed by

jamadden

Commit Message

Make load_current use a prepared statement in postgres

This shows gains up up to 40% for reading cold objects in zodbshooutout
0.6 tests with a fast local database.

BEFORE ANY (pg)

** concurrency=2 **
"Transaction",                postgresql
"Add 1000 Objects",                17202
"Update 1000 Objects",             14951
"Read 1000 Warm Objects",          11596
"Read 1000 Cold Objects",          12022
"Read 1000 Hot Objects",           60890
"Read 1000 Steamin' Objects",    2080069

WITH LOAD CURRENT

** concurrency=2 **
"Transaction",                postgresql
"Add 1000 Objects",                17896
"Update 1000 Objects",             17858
"Read 1000 Warm Objects",          14854
"Read 1000 Cold Objects",          16874
"Read 1000 Hot Objects",           62372
"Read 1000 Steamin' Objects",    2101126

Run Details

4994 of 5330 relevant lines covered (93.7%)

9.48 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	564.1 (ENV=mysql)	23 Jan 2017 08:24PM UTC	85.82	Travis Job 564.1
2	564.2 (ENV=postgres)	23 Jan 2017 08:24PM UTC	87.43	Travis Job 564.2
4	564.4 (ENV=pymysql)	23 Jan 2017 08:24PM UTC	85.61	Travis Job 564.4
5	564.5 (ENV=umysqldb)	23 Jan 2017 08:25PM UTC	85.61	Travis Job 564.5
6	564.6 (ENV=mysql)	23 Jan 2017 08:27PM UTC		Travis Job 564.6
7	564.7 (ENV=postgres)	23 Jan 2017 08:28PM UTC		Travis Job 564.7
9	564.9 (ENV=mysql)	23 Jan 2017 08:30PM UTC	85.78	Travis Job 564.9
10	564.10 (ENV=postgres)	23 Jan 2017 08:30PM UTC	87.39	Travis Job 564.10
12	564.12 (ENV=pymysql)	23 Jan 2017 08:32PM UTC	85.55	Travis Job 564.12
13	564.13 (ENV=umysqldb)	23 Jan 2017 08:33PM UTC	86.34	Travis Job 564.13
14	564.14 (ENV=mysql)	23 Jan 2017 08:34PM UTC	85.82	Travis Job 564.14
15	564.15 (ENV=postgres)	23 Jan 2017 08:34PM UTC	87.39	Travis Job 564.15
17	564.17 (ENV=pymysql)	23 Jan 2017 08:37PM UTC	85.61	Travis Job 564.17

Source Files on build 564

Detailed source file information is not available for this build.

zodb / relstorage / 564
95%
master: 92%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 564

zodb / relstorage / 564 95% master: 92%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 564

zodb / relstorage / 564
95%
master: 92%

README BADGES
x