ZODB shootout results with and without a prepared statement for load_current

Environment.txt

Non-history-preserving storage Python 3 on Mac OS X 10.10.4 2.3 GHz Intel Core i7 16GB, Postgres 9.5

normal.txt

bash-3.2$ p3/e/bin/zodbshootout samples/sample.conf
p3/e/bin/zodbshootout samples/sample.conf
Testing postgresql with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=2 (threads? False)
  Running 1/3... add 0.1539s, update 0.1765s, warm 0.2289s, cold 0.2006s, hot 0.0336s, steamin 0.0011s
  Running 2/3... add 0.1540s, update 0.1761s, warm 0.2274s, cold 0.1988s, hot 0.0339s, steamin 0.0011s
  Running 3/3... add 0.1541s, update 0.1771s, warm 0.2285s, cold 0.2011s, hot 0.0338s, steamin 0.0011s
Testing zeo_fs with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=2 (threads? False)
  Running 1/3... add 0.2351s, update 0.2628s, warm 0.3470s, cold 0.3479s, hot 0.0275s, steamin 0.0008s
  Running 2/3... add 0.2341s, update 0.2615s, warm 0.3480s, cold 0.3501s, hot 0.0278s, steamin 0.0008s
  Running 3/3... add 0.2349s, update 0.2630s, warm 0.3526s, cold 0.3494s, hot 0.0276s, steamin 0.0008s

Results show objects written or read per second. Mean of 3

** concurrency=2 **
"Transaction",                postgresql, zeo_fs
"Add 1000 Objects",                12987,    8520
"Update 1000 Objects",             11328,    7621
"Read 1000 Warm Objects",           8762,    5727
"Read 1000 Cold Objects",           9991,    5728
"Read 1000 Hot Objects",           59235,   72387
"Read 1000 Steamin' Objects",    1760093, 2598949
bash-3.2$ p3/e/bin/zodbshootout samples/sample.conf -c4
p3/e/bin/zodbshootout samples/sample.conf -c4
Testing postgresql with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=4 (threads? False)
  Running 1/3... add 0.2095s, update 0.2733s, warm 0.2900s, cold 0.2625s, hot 0.0385s, steamin 0.0012s
  Running 2/3... add 0.1869s, update 0.2206s, warm 0.2920s, cold 0.2676s, hot 0.0419s, steamin 0.0011s
  Running 3/3... add 0.2068s, update 0.2324s, warm 0.2892s, cold 0.2625s, hot 0.0387s, steamin 0.0011s
Testing zeo_fs with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=4 (threads? False)
  Running 1/3... add 0.3416s, update 0.3757s, warm 0.5111s, cold 0.5126s, hot 0.0320s, steamin 0.0009s
  Running 2/3... add 0.3785s, update 0.3880s, warm 0.5031s, cold 0.5071s, hot 0.0330s, steamin 0.0008s
  Running 3/3... add 0.3397s, update 0.3721s, warm 0.5134s, cold 0.5031s, hot 0.0297s, steamin 0.0016s

Results show objects written or read per second. Mean of 3

** concurrency=4 **
"Transaction",                postgresql, zeo_fs
"Add 1000 Objects",                19893,   11323
"Update 1000 Objects",             16520,   10565
"Read 1000 Warm Objects",          13773,    7855
"Read 1000 Cold Objects",          15138,    7880
"Read 1000 Hot Objects",          100792,  126731
"Read 1000 Steamin' Objects",    3474050, 3684142

with prepared statement.txt

bash-3.2$ p3/e/bin/zodbshootout samples/sample.conf
p3/e/bin/zodbshootout samples/sample.conf
Testing postgresql with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=2 (threads? False)
  Running 1/3... add 0.1609s, update 0.1715s, warm 0.1724s, cold 0.1505s, hot 0.0338s, steamin 0.0011s
  Running 2/3... add 0.1641s, update 0.2235s, warm 0.1701s, cold 0.1522s, hot 0.0336s, steamin 0.0011s
  Running 3/3... add 0.1603s, update 0.1680s, warm 0.1731s, cold 0.1515s, hot 0.0342s, steamin 0.0012s
Testing zeo_fs with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=2 (threads? False)
  Running 1/3... add 0.2351s, update 0.2619s, warm 0.3490s, cold 0.3478s, hot 0.0272s, steamin 0.0008s
  Running 2/3... add 0.2339s, update 0.2616s, warm 0.3615s, cold 0.3488s, hot 0.0272s, steamin 0.0008s
  Running 3/3... add 0.2332s, update 0.2612s, warm 0.3461s, cold 0.3478s, hot 0.0271s, steamin 0.0007s

Results show objects written or read per second. Mean of 3

** concurrency=2 **
"Transaction",                postgresql, zeo_fs
"Add 1000 Objects",                12362,    8544
"Update 1000 Objects",             10656,    7646
"Read 1000 Warm Objects",          11638,    5679
"Read 1000 Cold Objects",          13213,    5745
"Read 1000 Hot Objects",           59034,   73593
"Read 1000 Steamin' Objects",    1753593, 2642192
bash-3.2$ p3/e/bin/zodbshootout samples/sample.conf -c4
p3/e/bin/zodbshootout samples/sample.conf -c4
Testing postgresql with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=4 (threads? False)
  Running 1/3... add 0.2066s, update 0.3490s, warm 0.2541s, cold 0.2013s, hot 0.0373s, steamin 0.0013s
  Running 2/3... add 0.2113s, update 0.3608s, warm 0.2211s, cold 0.2025s, hot 0.0371s, steamin 0.0012s
  Running 3/3... add 0.1847s, update 0.2151s, warm 0.2263s, cold 0.2012s, hot 0.0385s, steamin 0.0011s
Testing zeo_fs with objects_per_txn=1000, object_size=96, mappingtype=<class 'persistent.mapping.PersistentMapping'> and concurrency=4 (threads? False)
  Running 1/3... add 0.3261s, update 0.3646s, warm 0.5036s, cold 0.5076s, hot 0.0312s, steamin 0.0008s
  Running 2/3... add 0.3300s, update 0.3601s, warm 0.5031s, cold 0.5023s, hot 0.0303s, steamin 0.0008s
  Running 3/3... add 0.3221s, update 0.3564s, warm 0.5033s, cold 0.5036s, hot 0.0297s, steamin 0.0008s

Results show objects written or read per second. Mean of 3

** concurrency=4 **
"Transaction",                postgresql, zeo_fs
"Add 1000 Objects",                19913,   12267
"Update 1000 Objects",             12974,   11099
"Read 1000 Warm Objects",          17105,    7947
"Read 1000 Cold Objects",          19836,    7928
"Read 1000 Hot Objects",          106239,  131594
"Read 1000 Steamin' Objects",    3389855, 4977386