Update of /cvsroot/monetdb/MonetDB5/src/optimizer/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17201/optimizer/Tests
Modified Files:
tst4631.stable.out tst4700.stable.out tst4900.stable.out
Log Message:
The code has been tested for robustness. The minimal size of the
instruction argument list was downgraded from 9 to 4. It uncovered
sloppyness in taking care of a possibly enlarged instruction.
The code in SQL code generation was properly done.
The look back for constants has been reduced a little (36->32 instructions)
without a major loss of opportunities.
The BMP, partitions and mergetable optimizer are still the focus
of further improvements. Mergetable optimizer first run indicates
about 60 test problems.
Index: tst4700.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/tst4700.stable.out,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -d -r1.23 -r1.24
--- tst4700.stable.out 28 Dec 2006 22:16:18 -0000 1.23
+++ tst4700.stable.out 17 Aug 2007 13:56:58 -0000 1.24
@@ -211,15 +211,15 @@
d0 := calc.-(t1,t0); # 86 CALCbinarySUBlnglng
(d0:lng)<-(t1:lng)(t0:lng)
io.printf("#select 0.8 %d",d0); # 87 IOprint_formatted_lng
(_66:void)<-(_67:str)(d0:lng)
cnt := aggr.count(z8); # 88 ALGcount_bat (cnt:int)<-(z8:bat[:oid,:lng])
- io.printf(" count %d\n",cnt); # 89 IOprint_formatted_int
(_68:void)<-(_34:str)(cnt:int)
+ io.printf(" count %d\n",cnt); # 89 IOprint_formatted_int
(_68:void)<-(_69:str)(cnt:int)
r3 := calc.+(r3,r2); # 90 CALCbinaryADDlnglng
(r3:lng)<-(r3:lng)(r2:lng)
t0 := alarm.usec(); # 91 ALARMusec (t0:lng)
z9 := algebra.select(b,mi,r3); # 92 ALGselect
(z9:bat[:oid,:lng])<-(b:bat[:oid,:lng])(mi:lng)(r3:lng)
t1 := alarm.usec(); # 93 ALARMusec (t1:lng)
d0 := calc.-(t1,t0); # 94 CALCbinarySUBlnglng
(d0:lng)<-(t1:lng)(t0:lng)
- io.printf("#select 1.0 %d",d0); # 95 IOprint_formatted_lng
(_70:void)<-(_71:str)(d0:lng)
+ io.printf("#select 1.0 %d",d0); # 95 IOprint_formatted_lng
(_71:void)<-(_72:str)(d0:lng)
cnt := aggr.count(z9); # 96 ALGcount_bat (cnt:int)<-(z9:bat[:oid,:lng])
- io.printf(" count %d\n",cnt); # 97 IOprint_formatted_int
(_72:void)<-(_73:str)(cnt:int)
+ io.printf(" count %d\n",cnt); # 97 IOprint_formatted_int
(_73:void)<-(_69:str)(cnt:int)
t0 := alarm.usec(); # 98 ALARMusec (t0:lng)
sr := bat.reverse(b); # 99 BKCreverse
(sr:bat[:lng,:oid])<-(b:bat[:oid,:lng])
s := algebra.sort(sr); # 100 ALGhsort
(s:bat[:lng,:oid])<-(sr:bat[:lng,:oid])
Index: tst4631.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/tst4631.stable.out,v
retrieving revision 1.38
retrieving revision 1.39
diff -u -d -r1.38 -r1.39
--- tst4631.stable.out 23 Mar 2007 22:30:36 -0000 1.38
+++ tst4631.stable.out 17 Aug 2007 13:56:57 -0000 1.39
@@ -184,52 +184,52 @@
V69 := calc.lng(1); # 51 CALCint2lng (V69:lng)<-(_67:int)
V71 := calc.*(V69,100); # 52 CALCbinaryMULlngint
(V71:lng)<-(V69:lng)(_69:int)
V72:bat[:oid,:flt] := user.bind("sys","lineitem","l_discount",0); # 53
(V72:bat[:oid,:flt])<-(_40:str)(_41:str)(_71:str)(_42:int)
- V74:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 54
(V74:bat[:oid,:oid])<-(_40:str)(_41:str)(_42:int)
+ V74:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 54
(V74:bat[:oid,:oid])<-(_73:str)(_74:str)(_75:int)
V78 := bat.reverse(V74); # 55 BKCreverse
(V78:bat[:oid,:oid])<-(V74:bat[:oid,:oid])
V79 := algebra.kdifference(V72,V78); # 56 ALGkdiff
(V79:bat[:oid,:flt])<-(V72:bat[:oid,:flt])(V78:bat[:oid,:oid])
V80 := algebra.join(V18,V79); # 57 ALGjoin
(V80:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V79:bat[:oid,:flt])
- V81:bat[:oid,:flt] := mal.multiplex("calc","-",V71,V80); # 58
OPTremapMultiplex
(V81:bat[:oid,:flt])<-(_77:str)(_78:str)(V71:lng)(V80:bat[:oid,:flt])
+ V81:bat[:oid,:flt] := mal.multiplex("calc","-",V71,V80); # 58
OPTremapMultiplex
(V81:bat[:oid,:flt])<-(_80:str)(_81:str)(V71:lng)(V80:bat[:oid,:flt])
V83 := batcalc.*(V67,V81); # 59 CMDbatMUL_flt_flt_flt
(V83:bat[:oid,:flt])<-(V67:bat[:oid,:flt])(V81:bat[:oid,:flt])
V85 := aggr.sum(V83,V32,V34); # 60 AX3aggrX3_sum3_flt_dbl
(V85:bat[:oid,:dbl])<-(V83:bat[:oid,:flt])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
- V86:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 61
(V86:bat[:oid,:oid])<-(_82:str)(_83:str)(_84:int)
+ V86:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 61
(V86:bat[:oid,:oid])<-(_73:str)(_74:str)(_75:int)
V87 := bat.reverse(V86); # 62 BKCreverse
(V87:bat[:oid,:oid])<-(V86:bat[:oid,:oid])
V88 := algebra.kdifference(V57,V87); # 63 ALGkdiff
(V88:bat[:oid,:flt])<-(V57:bat[:oid,:flt])(V87:bat[:oid,:oid])
V89 := algebra.join(V18,V88); # 64 ALGjoin
(V89:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V88:bat[:oid,:flt])
V90 := calc.lng(1); # 65 CALCint2lng (V90:lng)<-(_67:int)
V91 := calc.*(V90,100); # 66 CALCbinaryMULlngint
(V91:lng)<-(V90:lng)(_69:int)
- V92:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 67
(V92:bat[:oid,:oid])<-(_82:str)(_83:str)(_84:int)
+ V92:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 67
(V92:bat[:oid,:oid])<-(_73:str)(_74:str)(_75:int)
V93 := bat.reverse(V92); # 68 BKCreverse
(V93:bat[:oid,:oid])<-(V92:bat[:oid,:oid])
V94 := algebra.kdifference(V72,V93); # 69 ALGkdiff
(V94:bat[:oid,:flt])<-(V72:bat[:oid,:flt])(V93:bat[:oid,:oid])
V95 := algebra.join(V18,V94); # 70 ALGjoin
(V95:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V94:bat[:oid,:flt])
- V96:bat[:oid,:flt] := mal.multiplex("calc","-",V91,V95); # 71
OPTremapMultiplex
(V96:bat[:oid,:flt])<-(_77:str)(_78:str)(V91:lng)(V95:bat[:oid,:flt])
+ V96:bat[:oid,:flt] := mal.multiplex("calc","-",V91,V95); # 71
OPTremapMultiplex
(V96:bat[:oid,:flt])<-(_80:str)(_81:str)(V91:lng)(V95:bat[:oid,:flt])
V97 := batcalc.*(V89,V96); # 72 CMDbatMUL_flt_flt_flt
(V97:bat[:oid,:flt])<-(V89:bat[:oid,:flt])(V96:bat[:oid,:flt])
V98 := calc.lng(1); # 73 CALCint2lng (V98:lng)<-(_67:int)
V99 := calc.*(V98,100); # 74 CALCbinaryMULlngint
(V99:lng)<-(V98:lng)(_69:int)
- V100:bat[:oid,:flt] := user.bind("sys","lineitem","l_tax",0); # 75
(V100:bat[:oid,:flt])<-(_82:str)(_83:str)(_99:str)(_84:int)
- V102:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 76
(V102:bat[:oid,:oid])<-(_82:str)(_83:str)(_84:int)
+ V100:bat[:oid,:flt] := user.bind("sys","lineitem","l_tax",0); # 75
(V100:bat[:oid,:flt])<-(_73:str)(_74:str)(_99:str)(_75:int)
+ V102:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 76
(V102:bat[:oid,:oid])<-(_73:str)(_74:str)(_75:int)
V103 := bat.reverse(V102); # 77 BKCreverse
(V103:bat[:oid,:oid])<-(V102:bat[:oid,:oid])
V104 := algebra.kdifference(V100,V103); # 78 ALGkdiff
(V104:bat[:oid,:flt])<-(V100:bat[:oid,:flt])(V103:bat[:oid,:oid])
V105 := algebra.join(V18,V104); # 79 ALGjoin
(V105:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V104:bat[:oid,:flt])
- V106:bat[:oid,:flt] := mal.multiplex("calc","+",V99,V105); # 80
OPTremapMultiplex
(V106:bat[:oid,:flt])<-(_77:str)(_105:str)(V99:lng)(V105:bat[:oid,:flt])
+ V106:bat[:oid,:flt] := mal.multiplex("calc","+",V99,V105); # 80
OPTremapMultiplex
(V106:bat[:oid,:flt])<-(_80:str)(_105:str)(V99:lng)(V105:bat[:oid,:flt])
V108 := batcalc.*(V97,V106); # 81 CMDbatMUL_flt_flt_flt
(V108:bat[:oid,:flt])<-(V97:bat[:oid,:flt])(V106:bat[:oid,:flt])
V109 := aggr.sum(V108,V32,V34); # 82 AX3aggrX3_sum3_flt_dbl
(V109:bat[:oid,:dbl])<-(V108:bat[:oid,:flt])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
- V110:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 83
(V110:bat[:oid,:oid])<-(_82:str)(_83:str)(_84:int)
+ V110:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 83
(V110:bat[:oid,:oid])<-(_109:str)(_110:str)(_111:int)
V114 := bat.reverse(V110); # 84 BKCreverse
(V114:bat[:oid,:oid])<-(V110:bat[:oid,:oid])
V115 := algebra.kdifference(V50,V114); # 85 ALGkdiff
(V115:bat[:oid,:int])<-(V50:bat[:oid,:int])(V114:bat[:oid,:oid])
V116 := algebra.join(V18,V115); # 86 ALGjoin
(V116:bat[:oid,:int])<-(V18:bat[:oid,:oid])(V115:bat[:oid,:int])
V117 := aggr.avg(V116,V32,V34); # 87 AX3aggrX3_avg3_int
(V117:bat[:oid,:dbl])<-(V116:bat[:oid,:int])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
- V118:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 88
(V118:bat[:oid,:oid])<-(_82:str)(_83:str)(_84:int)
+ V118:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 88
(V118:bat[:oid,:oid])<-(_109:str)(_110:str)(_111:int)
V119 := bat.reverse(V118); # 89 BKCreverse
(V119:bat[:oid,:oid])<-(V118:bat[:oid,:oid])
V120 := algebra.kdifference(V57,V119); # 90 ALGkdiff
(V120:bat[:oid,:flt])<-(V57:bat[:oid,:flt])(V119:bat[:oid,:oid])
V121 := algebra.join(V18,V120); # 91 ALGjoin
(V121:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V120:bat[:oid,:flt])
V122 := aggr.avg(V121,V32,V34); # 92 AX3aggrX3_avg3_flt
(V122:bat[:oid,:dbl])<-(V121:bat[:oid,:flt])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
- V124:bat[:oid,:int] := mal.multiplex("calc","round",V122,100); # 93
OPTremapMultiplex
(V124:bat[:oid,:int])<-(_119:str)(_120:str)(V122:bat[:oid,:dbl])(_121:int)
- V126:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 94
(V126:bat[:oid,:oid])<-(_123:str)(_124:str)(_125:int)
+ V124:bat[:oid,:int] := mal.multiplex("calc","round",V122,100); # 93
OPTremapMultiplex
(V124:bat[:oid,:int])<-(_122:str)(_123:str)(V122:bat[:oid,:dbl])(_124:int)
+ V126:bat[:oid,:oid] := user.bind_dbat("sys","lineitem",0); # 94
(V126:bat[:oid,:oid])<-(_109:str)(_110:str)(_111:int)
V127 := bat.reverse(V126); # 95 BKCreverse
(V127:bat[:oid,:oid])<-(V126:bat[:oid,:oid])
V128 := algebra.kdifference(V72,V127); # 96 ALGkdiff
(V128:bat[:oid,:flt])<-(V72:bat[:oid,:flt])(V127:bat[:oid,:oid])
V129 := algebra.join(V18,V128); # 97 ALGjoin
(V129:bat[:oid,:flt])<-(V18:bat[:oid,:oid])(V128:bat[:oid,:flt])
V130 := aggr.avg(V129,V32,V34); # 98 AX3aggrX3_avg3_flt
(V130:bat[:oid,:dbl])<-(V129:bat[:oid,:flt])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
- V131 := mal.multiplex("calc","round",V130,100); # 99 OPTremapMultiplex
(V131:any)<-(_119:str)(_120:str)(V130:bat[:oid,:dbl])(_121:int)
+ V131 := mal.multiplex("calc","round",V130,100); # 99 OPTremapMultiplex
(V131:any)<-(_122:str)(_123:str)(V130:bat[:oid,:dbl])(_124:int)
V132 := aggr.count(V32,V32,V34); # 100 AX3aggrX3_count3Nils
(V132:bat[:oid,:int])<-(V32:bat[:oid,:oid])(V32:bat[:oid,:oid])(V34:bat[:oid,:oid])
end qry1; # 101
#
@@ -282,11 +282,13 @@
V81:bat[:oid,:flt] := mal.multiplex("calc","-",V71,V80);
V83 := batcalc.*(V62,V81);
V85 := aggr.sum(V83,V32,V34);
+ V96:bat[:oid,:flt] := mal.multiplex("calc","-",V71,V80);
+ V97 := batcalc.*(V62,V96);
V100:bat[:oid,:flt] := user.bind("sys","lineitem","l_tax",0);
V104 := algebra.kdifference(V100,V9);
V105 := algebra.join(V18,V104);
V106:bat[:oid,:flt] := mal.multiplex("calc","+",V71,V105);
- V108 := batcalc.*(V83,V106);
+ V108 := batcalc.*(V97,V106);
V109 := aggr.sum(V108,V32,V34);
V117 := aggr.avg(V55,V32,V34);
V122 := aggr.avg(V62,V32,V34);
Index: tst4900.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/tst4900.stable.out,v
retrieving revision 1.34
retrieving revision 1.35
diff -u -d -r1.34 -r1.35
--- tst4900.stable.out 18 May 2007 21:47:18 -0000 1.34
+++ tst4900.stable.out 17 Aug 2007 13:56:58 -0000 1.35
@@ -119,33 +119,33 @@
t18 := array.grid(100,8,14,0); # 19 ARRAYgrid_int
(t18:bat[:oid,:int])<-(_10:int)(_6:int)(_33:int)(_8:int)
t19 := array.grid(1,100,112,0); # 20 ARRAYgrid_int
(t19:bat[:oid,:int])<-(_7:int)(_10:int)(_36:int)(_8:int)
#t20 := batcalc.*(8,t19); # 21 (_37:str)
- t20 := array.grid(1,100,112,0,8); # 22 ARRAYgridShift_int
(t20:bat[:oid,:int])<-(_7:int)(_10:int)(_36:int)(_8:int)(_6:int)
+ t20 := array.grid(1,100,112,0,8); # 22 ARRAYgridShift_int
(t20:bat[:oid,:int])<-(_7:int)(_10:int)(_36:int)(_8:int)(_39:int)
t21 := batcalc.+(t18,t20); # 23 CMDbatADD_int_int_int
(t21:bat[:oid,:int])<-(t18:bat[:oid,:int])(t20:bat[:oid,:int])
t22 := batcalc.*(14,t21); # 24 CMDcstMULbat_int_int_int
(t22:bat[:oid,:int])<-(_33:int)(t21:bat[:oid,:int])
t23 := batcalc.+(t17,t22); # 25 CMDbatADD_int_int_int
(t23:bat[:oid,:int])<-(t17:bat[:oid,:int])(t22:bat[:oid,:int])
t24 := batcalc.oid(t23); # 26 CMDconvert_int_oid
(t24:bat[:oid,:oid])<-(t23:bat[:oid,:int])
t25 := algebra.join(t24,t16); # 27 ALGjoin
(t25:bat[:oid,:dbl])<-(t24:bat[:oid,:oid])(t16:bat[:oid,:dbl])
t30 := batcalc.oid(t21); # 28 CMDconvert_int_oid
(t30:bat[:oid,:oid])<-(t21:bat[:oid,:int])
- t31 := array.grid(1,800,1,0); # 29 ARRAYgrid_int
(t31:bat[:oid,:int])<-(_46:int)(_32:int)(_46:int)(_47:int)
+ t31 := array.grid(1,800,1,0); # 29 ARRAYgrid_int
(t31:bat[:oid,:int])<-(_47:int)(_32:int)(_47:int)(_48:int)
t32 := aggr.product(t25,t30,t31); # 30 AX3aggrX3_prod3_dbl_dbl
(t32:bat[:oid,:dbl])<-(t25:bat[:oid,:dbl])(t30:bat[:oid,:oid])(t31:bat[:oid,:int])
t33 := batcalc.*(t15,t32); # 31 CMDcstMULbat_dbl_dbl_dbl
(t33:bat[:oid,:dbl])<-(t15:dbl)(t32:bat[:oid,:dbl])
t34 := batcalc./(t8,t33); # 32 CMDcstDIVbat_dbl_dbl_dbl
(t34:bat[:oid,:dbl])<-(t8:dbl)(t33:bat[:oid,:dbl])
t40 := algebra.join(t6,t34); # 33 ALGjoin
(t40:bat[:oid,:dbl])<-(t6:bat[:oid,:oid])(t34:bat[:oid,:dbl])
- t41 := calc.dbl(-0.5); # 34 CALCflt2dbl (t41:dbl)<-(_53:flt)
-#t42:bat[:oid,:dbl] := bbp.bind("Query_14x1320"); # 35 (_54:str)
+ t41 := calc.dbl(-0.5); # 34 CALCflt2dbl (t41:dbl)<-(_54:flt)
+#t42:bat[:oid,:dbl] := bbp.bind("Query_14x1320"); # 35 (_55:str)
t42:bat[:oid,:dbl] := bbp.bind(s); # 36 CMDbbpbind
(t42:bat[:oid,:dbl])<-(s:str)
- t43 := array.grid(1056000,14,1,0); # 37 ARRAYgrid_int
(t43:bat[:oid,:int])<-(_57:int)(_33:int)(_46:int)(_47:int)
- t44 := array.grid(100,1320,112,0); # 38 ARRAYgrid_int
(t44:bat[:oid,:int])<-(_59:int)(_60:int)(_36:int)(_47:int)
-#t45 := batcalc.*(14,t44); # 39 (_61:str)
- t45 := array.grid(100,1320,112,0,14); # 40 ARRAYgridShift_int
(t45:bat[:oid,:int])<-(_59:int)(_60:int)(_36:int)(_47:int)(_33:int)
+ t43 := array.grid(1056000,14,1,0); # 37 ARRAYgrid_int
(t43:bat[:oid,:int])<-(_58:int)(_33:int)(_47:int)(_48:int)
+ t44 := array.grid(100,1320,112,0); # 38 ARRAYgrid_int
(t44:bat[:oid,:int])<-(_60:int)(_61:int)(_36:int)(_48:int)
+#t45 := batcalc.*(14,t44); # 39 (_62:str)
+ t45 := array.grid(100,1320,112,0,14); # 40 ARRAYgridShift_int
(t45:bat[:oid,:int])<-(_60:int)(_61:int)(_36:int)(_48:int)(_33:int)
t46 := batcalc.+(t43,t45); # 41 CMDbatADD_int_int_int
(t46:bat[:oid,:int])<-(t43:bat[:oid,:int])(t45:bat[:oid,:int])
t47 := batcalc.oid(t46); # 42 CMDconvert_int_oid
(t47:bat[:oid,:oid])<-(t46:bat[:oid,:int])
t48 := algebra.join(t47,t42); # 43 ALGjoin
(t48:bat[:oid,:dbl])<-(t47:bat[:oid,:oid])(t42:bat[:oid,:dbl])
- t49:bat[:oid,:dbl] := bbp.bind("TREC2003_test_mus_14x8x32318"); # 44
CMDbbpbind (t49:bat[:oid,:dbl])<-(_67:str)
- t51 := array.grid(132000,8,14,0); # 45 ARRAYgrid_int
(t51:bat[:oid,:int])<-(_69:int)(_70:int)(_71:int)(_47:int)
- t52 := array.grid(1,100,147840,0); # 46 ARRAYgrid_int
(t52:bat[:oid,:int])<-(_46:int)(_59:int)(_73:int)(_47:int)
+ t49:bat[:oid,:dbl] := bbp.bind("TREC2003_test_mus_14x8x32318"); # 44
CMDbbpbind (t49:bat[:oid,:dbl])<-(_68:str)
+ t51 := array.grid(132000,8,14,0); # 45 ARRAYgrid_int
(t51:bat[:oid,:int])<-(_70:int)(_39:int)(_71:int)(_48:int)
+ t52 := array.grid(1,100,147840,0); # 46 ARRAYgrid_int
(t52:bat[:oid,:int])<-(_47:int)(_60:int)(_73:int)(_48:int)
#t53 := batcalc.*(8,t52); # 47 (_74:str)
- t53 := array.grid(1,100,147840,0,8); # 48 ARRAYgridShift_int
(t53:bat[:oid,:int])<-(_46:int)(_59:int)(_73:int)(_47:int)(_70:int)
+ t53 := array.grid(1,100,147840,0,8); # 48 ARRAYgridShift_int
(t53:bat[:oid,:int])<-(_47:int)(_60:int)(_73:int)(_48:int)(_76:int)
t54 := batcalc.+(t51,t53); # 49 CMDbatADD_int_int_int
(t54:bat[:oid,:int])<-(t51:bat[:oid,:int])(t53:bat[:oid,:int])
t55 := batcalc.*(14,t54); # 50 CMDcstMULbat_int_int_int
(t55:bat[:oid,:int])<-(_71:int)(t54:bat[:oid,:int])
t56 := batcalc.+(t43,t55); # 51 CMDbatADD_int_int_int
(t56:bat[:oid,:int])<-(t43:bat[:oid,:int])(t55:bat[:oid,:int])
@@ -156,31 +156,31 @@
t61 := batcalc.*(t59,t59); # 56 CMDbatMUL_dbl_dbl_dbl
(t61:bat[:oid,:dbl])<-(t59:bat[:oid,:dbl])(t59:bat[:oid,:dbl])
t71 := algebra.join(t57,t16); # 57 ALGjoin
(t71:bat[:oid,:dbl])<-(t57:bat[:oid,:oid])(t16:bat[:oid,:dbl])
t72 := batcalc./(t61,t71); # 58 CMDbatDIV_dbl_dbl_dbl
(t72:bat[:oid,:dbl])<-(t61:bat[:oid,:dbl])(t71:bat[:oid,:dbl])
- t76 := batcalc.*(1320,t52); # 59 CMDcstMULbat_int_int_int
(t76:bat[:oid,:int])<-(_60:int)(t52:bat[:oid,:int])
+ t76 := batcalc.*(1320,t52); # 59 CMDcstMULbat_int_int_int
(t76:bat[:oid,:int])<-(_61:int)(t52:bat[:oid,:int])
t77 := batcalc.+(t44,t76); # 60 CMDbatADD_int_int_int
(t77:bat[:oid,:int])<-(t44:bat[:oid,:int])(t76:bat[:oid,:int])
- t78 := batcalc.*(8,t77); # 61 CMDcstMULbat_int_int_int
(t78:bat[:oid,:int])<-(_70:int)(t77:bat[:oid,:int])
+ t78 := batcalc.*(8,t77); # 61 CMDcstMULbat_int_int_int
(t78:bat[:oid,:int])<-(_76:int)(t77:bat[:oid,:int])
t79 := batcalc.+(t51,t78); # 62 CMDbatADD_int_int_int
(t79:bat[:oid,:int])<-(t51:bat[:oid,:int])(t78:bat[:oid,:int])
t80 := batcalc.oid(t79); # 63 CMDconvert_int_oid
(t80:bat[:oid,:oid])<-(t79:bat[:oid,:int])
- t81 := array.grid(1,1056000,1,0); # 64 ARRAYgrid_int
(t81:bat[:oid,:int])<-(_92:int)(_57:int)(_92:int)(_93:int)
+ t81 := array.grid(1,1056000,1,0); # 64 ARRAYgrid_int
(t81:bat[:oid,:int])<-(_93:int)(_94:int)(_93:int)(_95:int)
t82 := aggr.sum(t72,t80,t81); # 65 AX3aggrX3_sum3_dbl_dbl
(t82:bat[:oid,:dbl])<-(t72:bat[:oid,:dbl])(t80:bat[:oid,:oid])(t81:bat[:oid,:int])
t83 := batcalc.*(t41,t82); # 66 CMDcstMULbat_dbl_dbl_dbl
(t83:bat[:oid,:dbl])<-(t41:dbl)(t82:bat[:oid,:dbl])
t84 := batmath.exp(t83); # 67 CMDsciencevoid_exp
(t84:bat[:oid,:dbl])<-(t83:bat[:oid,:dbl])
t85 := batcalc.*(t40,t84); # 68 CMDbatMUL_dbl_dbl_dbl
(t85:bat[:oid,:dbl])<-(t40:bat[:oid,:dbl])(t84:bat[:oid,:dbl])
t86 := batcalc.*(t7,t85); # 69 CMDbatMUL_dbl_dbl_dbl
(t86:bat[:oid,:dbl])<-(t7:bat[:oid,:dbl])(t85:bat[:oid,:dbl])
-#t87 := array.grid(100,1320,8,0); will save 30% by reuse # 70 (_99:str)
- t87 := array.grid(t81,100,1320,8,0); # 71 ARRAYgridBAT_int
(t87:bat[:oid,:int])<-(t81:bat[:oid,:int])(_101:int)(_102:int)(_70:int)(_93:int)
- t89 := batcalc.*(1320,t3); # 72 CMDcstMULbat_int_int_int
(t89:bat[:oid,:int])<-(_102:int)(t3:bat[:oid,:int])
+#t87 := array.grid(100,1320,8,0); will save 30% by reuse # 70 (_101:str)
+ t87 := array.grid(t81,100,1320,8,0); # 71 ARRAYgridBAT_int
(t87:bat[:oid,:int])<-(t81:bat[:oid,:int])(_103:int)(_104:int)(_76:int)(_95:int)
+ t89 := batcalc.*(1320,t3); # 72 CMDcstMULbat_int_int_int
(t89:bat[:oid,:int])<-(_104:int)(t3:bat[:oid,:int])
t90 := batcalc.+(t87,t89); # 73 CMDbatADD_int_int_int
(t90:bat[:oid,:int])<-(t87:bat[:oid,:int])(t89:bat[:oid,:int])
t91 := batcalc.oid(t90); # 74 CMDconvert_int_oid
(t91:bat[:oid,:oid])<-(t90:bat[:oid,:int])
- t92 := array.grid(1,132000,1,0); # 75 ARRAYgrid_int
(t92:bat[:oid,:int])<-(_92:int)(_107:int)(_92:int)(_93:int)
+ t92 := array.grid(1,132000,1,0); # 75 ARRAYgrid_int
(t92:bat[:oid,:int])<-(_93:int)(_109:int)(_93:int)(_95:int)
t93 := aggr.sum(t86,t91,t92); # 76 AX3aggrX3_sum3_dbl_dbl
(t93:bat[:oid,:dbl])<-(t86:bat[:oid,:dbl])(t91:bat[:oid,:oid])(t92:bat[:oid,:int])
t94 := batmath.log(t93); # 77 CMDsciencevoid_log
(t94:bat[:oid,:dbl])<-(t93:bat[:oid,:dbl])
- t95 := array.grid(1,100,1320,0); # 78 ARRAYgrid_int
(t95:bat[:oid,:int])<-(_92:int)(_101:int)(_102:int)(_93:int)
+ t95 := array.grid(1,100,1320,0); # 78 ARRAYgrid_int
(t95:bat[:oid,:int])<-(_93:int)(_103:int)(_104:int)(_95:int)
t96 := batcalc.oid(t95); # 79 CMDconvert_int_oid
(t96:bat[:oid,:oid])<-(t95:bat[:oid,:int])
- t97 := array.grid(1,100,1,0); # 80 ARRAYgrid_int
(t97:bat[:oid,:int])<-(_92:int)(_101:int)(_92:int)(_93:int)
+ t97 := array.grid(1,100,1,0); # 80 ARRAYgrid_int
(t97:bat[:oid,:int])<-(_93:int)(_103:int)(_93:int)(_95:int)
t98 := aggr.sum(t94,t96,t97); # 81 AX3aggrX3_sum3_dbl_dbl
(t98:bat[:oid,:dbl])<-(t94:bat[:oid,:dbl])(t96:bat[:oid,:oid])(t97:bat[:oid,:int])
top := t98; # 82 (top:bat[:oid,:dbl])<-(t98:bat[:oid,:dbl])
- io.table(t97,top); # 83 IOttable
(_115:void)<-(t97:bat[:oid,:int])(top:bat[:oid,:dbl])
+ io.table(t97,top); # 83 IOttable
(_117:void)<-(t97:bat[:oid,:int])(top:bat[:oid,:dbl])
end f1; # 84
# optimizer.expressionAccumulation("user","f1");
# optimizer.garbageCollector("user","f1");
@@ -203,9 +203,9 @@
t2 := array.grid(132000,8,1,0);
t3 := array.grid(1,100,10560,0);
t4 := array.grid(1,100,10560,0,8);
- _116 := algebra.reuse(t2);
- t5 := batcalc.+(_116,t2,t4);
- _116 := nil;
+ _118 := algebra.reuse(t2);
+ t5 := batcalc.+(_118,t2,t4);
+ _118 := nil;
t2 := nil;
t4 := nil;
t6 := batcalc.oid(t5);
@@ -225,15 +225,15 @@
t18 := array.grid(100,8,14,0);
t19 := array.grid(1,100,112,0);
t20 := array.grid(1,100,112,0,8);
- _117 := algebra.reuse(t18);
- t21 := batcalc.+(_117,t18,t20);
- _117 := nil;
+ _119 := algebra.reuse(t18);
+ t21 := batcalc.+(_119,t18,t20);
+ _119 := nil;
t18 := nil;
t20 := nil;
t22 := batcalc.*(14,t21);
- _118 := algebra.reuse(t17);
- t23 := batcalc.+(_118,t17,t22);
- _118 := nil;
+ _120 := algebra.reuse(t17);
+ t23 := batcalc.+(_120,t17,t22);
+ _120 := nil;
t17 := nil;
t22 := nil;
t24 := batcalc.oid(t23);
@@ -247,9 +247,9 @@
t25 := nil;
t30 := nil;
t31 := nil;
- _119 := algebra.reuse(t32);
- t33 := batcalc.*(_119,t15,t32);
- _119 := nil;
+ _121 := algebra.reuse(t32);
+ t33 := batcalc.*(_121,t15,t32);
+ _121 := nil;
t32 := nil;
t33 := batcalc./(t33,t8,t33);
t40 := algebra.join(t6,t33);
@@ -259,9 +259,9 @@
t43 := array.grid(1056000,14,1,0);
t44 := array.grid(100,1320,112,0);
t45 := array.grid(100,1320,112,0,14);
- _120 := algebra.reuse(t45);
- t46 := batcalc.+(_120,t43,t45);
- _120 := nil;
+ _122 := algebra.reuse(t45);
+ t46 := batcalc.+(_122,t43,t45);
+ _122 := nil;
t45 := nil;
t47 := batcalc.oid(t46);
t46 := nil;
@@ -271,9 +271,9 @@
t51 := array.grid(132000,8,14,0);
t52 := array.grid(1,100,147840,0);
t53 := array.grid(1,100,147840,0,8);
- _121 := algebra.reuse(t53);
- t54 := batcalc.+(_121,t51,t53);
- _121 := nil;
+ _123 := algebra.reuse(t53);
+ t54 := batcalc.+(_123,t51,t53);
+ _123 := nil;
t53 := nil;
t54 := batcalc.*(t54,14,t54);
t54 := batcalc.+(t54,t43,t54);
@@ -282,7 +282,7 @@
t54 := nil;
t58 := algebra.join(t57,t49);
t49:bat[:oid,:dbl] := nil;
- _122 := nil;
+ _124 := nil;
t48 := nil;
t58 := nil;
#t61 := batcalc.pow(t59,t9);
@@ -292,9 +292,9 @@
t16:bat[:oid,:dbl] := nil;
t59 := batcalc./(t59,t59,t71);
t71 := nil;
- _123 := algebra.reuse(t52);
- t76 := batcalc.*(_123,1320,t52);
- _123 := nil;
+ _125 := algebra.reuse(t52);
+ t76 := batcalc.*(_125,1320,t52);
+ _125 := nil;
t52 := nil;
t76 := batcalc.+(t76,t44,t76);
t44 := nil;
@@ -306,11 +306,11 @@
t81 := array.grid(1,1056000,1,0);
t59 := nil;
t80 := nil;
- _124 := nil;
+ _126 := nil;
t82 := nil;
t83 := nil;
- _125 := algebra.reuse(t40);
- _125 := nil;
+ _127 := algebra.reuse(t40);
+ _127 := nil;
t40 := nil;
t84 := nil;
t85 := batcalc.*(t85,t7,t85);
@@ -318,9 +318,9 @@
#t87 := array.grid(100,1320,8,0); will save 30% by reuse
t87 := array.grid(t81,100,1320,8,0);
t81 := nil;
- _126 := algebra.reuse(t3);
- t89 := batcalc.*(_126,1320,t3);
- _126 := nil;
+ _128 := algebra.reuse(t3);
+ t89 := batcalc.*(_128,1320,t3);
+ _128 := nil;
t3 := nil;
t89 := batcalc.+(t89,t87,t89);
t87 := nil;
@@ -343,13 +343,13 @@
barrier always := true;
t42:bat[:oid,:dbl] := bbp.bind(s);
t48 := algebra.join(t47,t42);
- _122 := algebra.reuse(t48);
- t59 := batcalc.-(_122,t48,t58);
+ _124 := algebra.reuse(t48);
+ t59 := batcalc.-(_124,t48,t58);
t82 := aggr.sum(t59,t80,t81);
- _124 := algebra.reuse(t82);
- t83 := batcalc.*(_124,t41,t82);
+ _126 := algebra.reuse(t82);
+ t83 := batcalc.*(_126,t41,t82);
t84 := batmath.exp(t83);
- t85 := batcalc.*(_125,t40,t84);
+ t85 := batcalc.*(_127,t40,t84);
t93 := aggr.sum(t85,t91,t92);
t94 := batmath.log(t93);
t98 := aggr.sum(t94,t96,t97);
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-checkins
