non relational pub sub index test

commands

$CLI -h one DROP TABLE messages
$CLI -h one CREATE TABLE messages "(id int primary key, cat INT, text TEXT)"; 
$CLI -h one CREATE INDEX nrl:messages:index ON messages "PUBLISH MSG:\$cat message=\$text"
NUM=1000000; 
taskset -c 1 ./redisql-benchmark -h one  -n $NUM -r $NUM -c 200 -SRM 4 -MSG

no index

  1000068 requests completed in 14.35 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 0 milliseconds
0.88% <= 1 milliseconds
32.51% <= 2 milliseconds
99.89% <= 3 milliseconds
99.95% <= 4 milliseconds
99.96% <= 5 milliseconds
99.97% <= 6 milliseconds
99.99% <= 7 milliseconds
99.99% <= 8 milliseconds
99.99% <= 17 milliseconds
99.99% <= 20 milliseconds
99.99% <= 21 milliseconds
99.99% <= 23 milliseconds
99.99% <= 24 milliseconds
99.99% <= 32 milliseconds
99.99% <= 38 milliseconds
99.99% <= 55 milliseconds
99.99% <= 61 milliseconds
99.99% <= 62 milliseconds
100.00% <= 63 milliseconds
100.00% <= 64 milliseconds
100.00% <= 65 milliseconds
100.00% <= 200 milliseconds
69715.44 requests per second

pubsub non-rel-index

  1000001 requests completed in 15.28 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

1.51% <= 1 milliseconds
36.40% <= 2 milliseconds
76.59% <= 3 milliseconds
99.90% <= 4 milliseconds
99.92% <= 5 milliseconds
99.95% <= 6 milliseconds
99.98% <= 7 milliseconds
99.98% <= 8 milliseconds
99.98% <= 9 milliseconds
99.98% <= 10 milliseconds
99.98% <= 11 milliseconds
99.98% <= 12 milliseconds
99.98% <= 13 milliseconds
99.98% <= 14 milliseconds
99.98% <= 15 milliseconds
99.98% <= 16 milliseconds
99.98% <= 17 milliseconds
99.98% <= 18 milliseconds
99.98% <= 19 milliseconds
99.98% <= 20 milliseconds
99.98% <= 21 milliseconds
99.98% <= 22 milliseconds
99.98% <= 23 milliseconds
99.98% <= 24 milliseconds
99.98% <= 25 milliseconds
99.98% <= 26 milliseconds
99.98% <= 27 milliseconds
99.98% <= 28 milliseconds
99.98% <= 29 milliseconds
99.98% <= 30 milliseconds
99.98% <= 31 milliseconds
99.98% <= 32 milliseconds
99.98% <= 33 milliseconds
99.98% <= 34 milliseconds
99.98% <= 35 milliseconds
99.98% <= 37 milliseconds
99.98% <= 38 milliseconds
99.98% <= 39 milliseconds
99.98% <= 40 milliseconds
99.99% <= 41 milliseconds
99.99% <= 42 milliseconds
99.99% <= 43 milliseconds
99.99% <= 44 milliseconds
99.99% <= 45 milliseconds
99.99% <= 46 milliseconds
99.99% <= 47 milliseconds
100.00% <= 48 milliseconds
100.00% <= 49 milliseconds
100.00% <= 50 milliseconds
100.00% <= 51 milliseconds
100.00% <= 53 milliseconds
100.00% <= 54 milliseconds
100.00% <= 55 milliseconds
100.00% <= 56 milliseconds
100.00% <= 58 milliseconds
100.00% <= 59 milliseconds
100.00% <= 202 milliseconds
65423.68 requests per second

setup

ONE:
taskset -c 1 ./redisql-server
taskset -c 2 $CLI SUBSCRIBE MSG:000100000003 > /dev/null
taskset -c 3 $CLI SUBSCRIBE MSG:000100000004 > /dev/null

TWO:
taskset -c 2 $CLI -h one SUBSCRIBE MSG:000100000001 >/dev/null
taskset -c 3 $CLI -h one SUBSCRIBE MSG:000100000002 >/dev/null
NUM=1000000; taskset -c 1 ./redisql-benchmark -h one  -n $NUM -r $NUM -c 200 -SRM 4 -MSG