test_50.mils

来自「一个内存数据库的源代码这是服务器端还有客户端」· MILS 代码 · 共 32 行

setoid(oid(2000000));
# Testing effect on join ordering
load("k10_unique1");
var k10_unique1:=bat("k10_unique1");
var c:= k10_unique1.select(0,9); 
printf("#~BeginVariableOutput~#\n"); cpu().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); memory().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); io().print(); printf("#~EndVariableOutput~#\n");
k10_unique1.join(c).count().print();commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit();
k10_unique1.join(c);commit(); 
printf("#~BeginVariableOutput~#\n"); cpu().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); memory().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); io().print(); printf("#~EndVariableOutput~#\n");


c.join(k10_unique1).count().print();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
c.join(k10_unique1).count();commit();
printf("#~BeginVariableOutput~#\n"); cpu().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); memory().print(); printf("#~EndVariableOutput~#\n");printf("#~BeginVariableOutput~#\n"); io().print(); printf("#~EndVariableOutput~#\n");
quit();