matriv

Statement: select count(*) from uservisits where duration != 10

Concurrency: 1 Iterations: 1000

With 3 value logic

Run #1

Runtime (in ms):

mean: 23.403 ± 0.734

matriv

Benchmark                    Mode  Cnt         Score        Error  Units
MyBenchmark.testReady       thrpt  200  65138596.553 ± 559898.434  ops/s
MyBenchmark.testReflection  thrpt  200    837419.902 ±  20471.042  ops/s

public class MyBenchmark {

    private static final String routingHashFunctionClass = "com.jenkov.DjbHashFunction";
    private static Method method;
    static {
        try {

matriv

Benchmark                       Mode  Cnt          Score         Error  Units
MyBenchmark.testConcatenation  thrpt   50  336375330.671 ± 2979060.438  ops/s
MyBenchmark.testFormat         thrpt   50    1572940.434 ±   24415.477  ops/s
MyBenchmark.testStringBuilder  thrpt   50   43651155.268 ± 1694489.589  ops/s

import org.openjdk.jmh.annotations.Benchmark;
import org.openjdk.jmh.infra.Blackhole;

public class MyBenchmark {

matriv

Empty map
Benchmark                               Mode  Cnt         Score        Error  Units
MyBenchmark.testMethodIfNull           thrpt  200  24978901.585 ± 199666.148  ops/s
MyBenchmark.testMethodComputeIfAbsent  thrpt  200  25946379.688 ±  99020.534  ops/s
MyBenchmark.testMethodPutIfAbsent      thrpt  200  24569458.147 ± 151086.965  ops/s

Map with 1000 entries
Benchmark                               Mode  Cnt      Score     Error  Units
MyBenchmark.testMethod                 thrpt  200  16188.897 ±  80.173  ops/s
MyBenchmark.testMethodComputeIfAbsent  thrpt  200  17178.152 ± 145.505  ops/s

matriv

INSERT INTO t(a,b,c,d,l) values(0,0,0,0,0);
INSERT INTO t(a,b,c,d,l) values(1,1,1,1,1);
INSERT INTO t(a,b,c,d,l) values(2,2,2,2,2);
INSERT INTO t(a,b,c,d,l) values(3,3,3,3,3);
INSERT INTO t(a,b,c,d,l) values(4,4,4,4,4);
INSERT INTO t(a,b,c,d,l) values(5,5,5,5,5);
INSERT INTO t(a,b,c,d,l) values(6,6,6,6,6);
INSERT INTO t(a,b,c,d,l) values(7,7,7,7,7);
INSERT INTO t(a,b,c,d,l) values(8,8,8,8,8);
INSERT INTO t(a,b,c,d,l) values(9,9,9,9,9);

matriv

curl --data "{
	\"stmt\": \"UPDATE t SET l = ? WHERE a = ?\",
    \"bulk_args\": [ [0,0], 
[-1,1], 
[-2,2], 
[-3,3], 
[-4,4], 
[-5,5], 
[-6,6], 
[-7,7], 

matriv

    @Override
    protected Settings nodeSettings(int nodeOrdinal) {
        return Settings.builder()
            .put(super.nodeSettings(nodeOrdinal))
            .put("threadpool.bulk.type", "fixed")
            .put("threadpool.bulk.queue_size", "500")
            .put("threadpool.bulk.processors", "8")
            .build();
    }

matriv

select x1, y1, z1 from t1
union all
select x2, y2, z2 from (select * from t2 order by y2 limit 10) b
order by 1

select t1.fetchid, x1, null from t1 order by x1
select t2.fetchid, x2, y2   from t2 order by y2 limit 10
order by (IC(1))

Fetch:

matriv

select x1, y1, z1 from t1
union all
select x2, y2, z2 from (select * from t2 order by y2 limit 10) b
order by 1

select t1.fetchid, x1, null from t1 order by x1
select t2.fetchid, x2, y2   from t2 order by y2 limit 10
order by (IC(1))

Fetch:

matriv

----

select a as x from t1
union all
select d from t2
order by x limit 2

1st rel:
collect: _docId, a from t1
merge: apply ordering by a and limit 2