用conditionalFilter试试:
symbol=`a`a`a`b`b`b`c`c`c
order_id=1 2 3 1 2 3 1 2 3
A = table(symbol, date,order_id)
order_id = 1 2 3 1 2 4 1 2 4
B =table(symbol, date,order_id)
timer(1000) {
filter1= dict(STRING, ANY)
filter1.dictUpdate!(append!, A.symbol, A.order_id, x->array(x.type(), 0, 512).append!(x))
select * from B where not conditionalFilter( order_id,symbol,filter1)
}//执行1000次耗费77ms
timer(1000) select * from lj(A,B,`symbol`order_id) where B.date=NULL //执行1000次耗费183ms
在我电脑上测试,conditionalFilter的性能比lj提高约1倍。