diff --git a/10m-final-time-slownet.pdf b/10m-final-time-slownet.pdf new file mode 100644 index 0000000000000000000000000000000000000000..44f004455e0381a4dfcc9579ba9c15aca1ce39ea GIT binary patch literal 4511 zcmZ`-c|6o>7q>*2%DyxaKO$88%wX&lV~gzjnlT2GF~clb$G&B|S+bNhS<-bS$rk0x zQey0-RFWdH6r!PeXWU!&zW2WG@4x5!ob#OXoX`3GKIi+$Sn3-pz!X&=GSSn~Z=z|@ zBd$aU3{V0Hp64Li+7J*)#GuGn0$v|Q#sG5qns6l;LP;I23{z6oP*#$MfMx`*|GQ_4 zCF2-g)_@Ta72u0SlK=|}Ie0CL|9zaRP$Ddoi z?w~b>M4%ASjPq3faURp)M>)=5@IGW;KvfL}fQDEcnQ;No5XY#EJ_b$j!Z6b&kr^fP zhXfat+nN#%>h5b_u3h1an@RV%yV|5D!GEs0;@50sCeq-v9YlA(vE4VSPJJr|*z1(t z8T_{4>z7q@f(K-m>86eAhE|E?b!YX$6PIz@+6q&g;weGT3B}z?uY{#f3e6C;2>n@3 zi6MwD{NFV|?u<8%I5-uu(4g~~h~b>q~;fZPji9&6$SDcC&MYe!%3`bj;> zllPX_b@?Ty^#jfl3dodKE4F5F3IwN&zkL@tW<|NYZ1gd9o^>t4alI;U(iS9!8)7PN2gyyAijjx9MY0?&9IGQ5`U$X@X6Z$;+}MAReW1*S z!e#!2$`y#+Lk#h(qy6^e!_1-7UC+DH!qo#;)3ozgpFJ)c zFEgTv&=*DZh&{b3i)mE5uRfmHch6>b<;=(U<{YcgNXf~4AG2c3rXg!Cf@y@aT_HVj z`m9EFS{>5LBzJOClWMC?c_tR8y!W_wOl_UxSRM2JCVKwf_}(T_+;T!^SXG6a%D3Wa ziIRcBAx7i>*+hR*fZ5@Hbl?vP{L%TKDb|YwxB$$Kw+7r8%pg!09nR=YGmIA&rAG(` zT$C7lYH%e04nw&8jU>z_|IyS8E~0HPWWWVv{0$fpFu`Ou2x!P42%xPE8ma*><{>*2 z0}X=7MmA*T&p=z7c^o4ojzF{tK%sXKkYsJ72dMrq|BIANh#AiXJdH%^p-31n0Kv3! z`$2Q&>c<^*nZ&{~gMj*&^H?;7c_?Vkpf30)0pY3|i2unzW==mDSeO%JYcnC7NNZDT zv&`g8&K~shwPrKk-)5YlcofFPYjXc0ixfiNHbCDhqhb$SZYrt_nNcT|9M5W1x3CMU zKN=VyD4KKHs|Nb&Zpd=~l~)oQ5q`yOv==_h)bSRUi`%grzn^jBirQD|DENA|D=96- z$746^z7-aB9LrQdeZ8LWrXgECTlmvdT)x1jNLvdx@MY`h$jQ_WmhZ*c%}!D<7R$WU z*-x7ju27MO>N*YuGL04w^X{ma4JermNIAv8?XyUqj=O|^&d2a*tit28p?#!*Y0S#Z zr0knC4gU7j3=gQt?4HeLc>57_EctZ8scynd9W>k=!6KJAsrZg$3VWJ$i&PT{5oinoNjTR)gS?sM$M zo%?)EEId=}Y`Stuy8=C6Q!#=US@i)C!Kj9k1KBY(9{bl`lVCD0KH>C9aAN=bL;uj(QIZ^*!lvA{`G`;OY{J zF^%^x1+a(nF2z}N=1%cBLQY0k@XY}ixJE{b21 zXihfHsO)tS`$$44e)?)oseLJ;tlDa~WntBcQM*yObC7jDGef_t{X+wD zEac;w(83f&Lx++pgNNqo=lIst=|Y^brRY>x`hmzZVn>AP+3KP7q9f@V@zCy6R7IWR zubSgx3(5Pth&MfPuse`2-Z1_!4y|-*?BQv0z#a9ouG;2F#~#>CIS0rFI0OhZLGSXv z$f;#y`w0F(#%0ab<-x(U|nhc^(6BL0av4% z5*$x!>uXzx$+XK@8GB13O)>fw(ROTLo5XH|04 z@#rqO6+!!BqjKbygva@#Vp?fZn` z+i<%HLk(LEWJo^W(az1is+qh~Aj7{?>Wz=xqXCBQo8TLJTV5zRxzOacNs&p~qd+0~L#3ia>~rte;B*w7Lf5iWu(PmhpFc8&7&}&7 zJNB+Br0V0C$>_5&!_k-5l}D+gBcqMigRZ|CIfc!`#`(>h`!J+_<0F~dKfO$X>ZTP!WCZbNRxeZIzR*JEZ>QjeUy zHh@lmbY^7?RC%qzD#)souN0Y<^_JKc<tI+t+#n6p4F8cAW(q9kJ+vql&nw*lH z9Go?rjr%_)9PbqDbW8Y}P@9&T=9!8(K!NJO?UlKe2GsDX?S6WQKs6`tVGm-zAo>y9 zO!=)^umy_zZP222#5*nj9T$Gg`4M1?_Nb78#{&J@uz{3BWUoj6Ro^RPm!!d`{e zuRoy>|H7Brli(@fYvVhDUcFJ1ukhqf_vdG>pIl!x-1l;%)STCRw>Cb} z;q)Q==@$`^3e(G`DSc%j-K(3c2WQio=bMSH3vT83eU18!ZFuV-x1jW}*e!M*Do>G7 zR!>~zb)V{4U7C;kxVuy>ckL6L&u5d*@`MM^X{`^!1{0?R-r6jZUOCXzCK|_r9?@PB z;$O)}-j2NZ9r0b1)tPlN>Rr_JQ$6=DMN@UJm2l{e>GH(%#~5_zNCp^t^nSkBy1IXM z?`%+f%wW{uV(G^3shv6TREcyhp1rkPkq1x$R=h*^qFOv2#^i9+O0`M#NiFN=>z}?F zS|(H`aP>;r*`DB@>>guuji*Dmd-6zx@sf_l0fu7FE(K$IIKz_nJK~{w%L^q)mrCHzP05)|jt? zYYX0>yb4dOe_Wqjf32?|chMCg1L0T2ASY68wRWjY&_<&k=-+aOUw)HgleKz8O>@Jz zh*+dV@Mxa+WY#D9iMo2vJ=(d$ZOEm><>nm^a{25dy4_%P`HfJAg<3^to%U`*e{@4! z1J*B6?zZA_FuYmO+sz`we(3Vmy7hP^_CifS_n(_k49 z(;CxbCa(zZ@a>zI`W-Hvr9R8Njk)=_6i2gvZ2x+E;rV3aAvp&{8YuBx{8k%jH`?f7 zdahRPhr5<22dl=Eo2Iu+ouRH1ZWzmkhIuN*WZgK;!7QxCd$Ho#lh%;d+7BO}j@Vb) zIXG|NYdx0xL+{ZCILi`}sd-e5EpddQ+ULlAdQ0=^vg^0scSgL9cpsg_PVGCz2$hYw;%tf1iQa*$Qzq_IA zn!vp4OO3Hh!!nEM3*sjZ2H$S%DX)AJ*0;PNF`{Ena(x>-!S(xvs{+O5?}`gfT%yds ze?K#VZZi#CF1VmWssZm3R&aw8tFz&>!uJ~=PKLZ(->%y`Ad>Fx<@TXvCg3{heniQe z-CGixoQF8I62%f*KrOc=Xpvg@bn@1v5r?+gqE_L6#o^xVjMocRPY5rKnM!*E+X(KI-N30flvQG9S=KEU2-8soG zsIIsH{nf+Ije3qyWx)Q56?Ul1t z_nv+qUcxMspRRp%fYy4u=iar7BuyzS_rIo}uipc!u0$j;(*K9I$v@JPG>)fPnf~Z*L4kVlp+P3!tJ3 z`eX4F5}<(q11SVD28Zz`LtrW@pcjFmib*6a0QwM7=NU6D3Qb{-x@asBP4V}}VS)jW zjKz5|Ab%8^NWcT2ClSLmWO$;`XohNqfL>TeC=!+gfQonm*$d+hfW)07(TvF-heQ1h z_od){P(+G94n-jYAi;-#$M`X#p>|FtF(-Gozsc>LS^vi%{)gV)Q39Y1#gn`vznLII zVwj`+87VQ;!A@QNu(8GZV@L|t1b-AB0{*BBz^v)t1$r8A|qp9VF>vTx+k8V literal 0 HcmV?d00001 diff --git a/10m-final-time-unlimited.pdf b/10m-final-time-unlimited.pdf new file mode 100644 index 0000000000000000000000000000000000000000..e4dee755b381bbc9aae536ae3f1a7e81d6ba74e4 GIT binary patch literal 4492 zcmZ`-c|4SB8x|o`*_Woo%RwaGnK5=sOhY7Vb~25@9J6SatYgnkNrbEs#c?ELi|SZQ z3`R<6K_RjfMX0_Rr#k05=lkCO-s`!y=lG{1=B%jz+sxY8ZZ?IXi4_^zi0M%8iDO) z3z$+c{=RrD6|kby{OL5dn>B^(MaSYOoKp>TggTOqZRR3#AQi~LgAg3ai&F*SXEgw5 zALNe%KoblNLm>MApf$z^M+G$42DZRo4%+{6;Mj4jDL4}CyE$k=CehfxR6u9b9kj(! z$#e>q9S`}BcpQTt?Kp-b`Otg;O-%#jCK=YZ>zF-(J=XKXP zp#)FCt*Wc;Zh|33g~BQRh!zFsFhlh*h)iO@Gjc)cjVF@g;gIe(X9lu;aOWCx8Dn<@ zzluMu2VVUSWOezRuzot-I4ZIJfjO1A}R`(f>a7^ zniO)bwALfe55am$0w{_*RFAC;$=&TiW`wd+(y-G(nAY@vS_on1B5--V^NHHsn&-X|Te|~M7 z0p=S_KCV<{4J71{-yB|0ksc(|%7QMaFE(Uvbl3%b4noXU+>yQOLX*n`p>ZOuq+89h z=X$njNTV!D&MWOQHo-347;PyyuJnclwO24tA69NKxhPod=XwTxvVi&izCwkK{vuyS z3|+ekU72*V#?H+`@snU>e#oxzj^`oB;Q6r$UW~>$w9mQ7l@HIfW1@^~=i(bGPOYLY zDk$W2m{U7#7v~gidQ#EeVhS$ly!zDJTfYs+T|f7GM2YHLKYy!$dsFN0rjFP}ZuHC9 z-I5=@-)}#2=&?lult}KJaJ@FkKz=psI61J9dYL`t-zVn#ymQ9+&vE-P?|+UtXo2^l z0GR4jxgWW_xs;#Lp zp!vi6F9vcTPCi%gsELU&hKln7v^ZAoKRC_#`*Fv^92Su{NkA0t3?7T)1O<wnUXQ`1kne;PO)X-^v@jaPGy(*zEZwD>(UVbUN66ROX!hG(t zz!+}gI=>Ok`^PaSfruSNPU2%z9q}niKA!wrb}Vx75V&6X*VGtGuA;fKxkH~M6SBot zrCOQ z)zHx6T3pH(M%5>&c3uQE>;+{+l-fiP*DJI8Cl?1nr-w|j9-)rDhc4=(3T5$7B{#d+ zlytGAF(%V;DyickOi(-JmvQ)$Y^byJ7=_E5x#27xM1CbfHzACrdC`^V+dA|rC5aOlUzrfhuY0C4tH)$X{D{q|{^_Ah+aO`Whq(XQq))a+k z5Vh%hm$Tu*jRd%k81c*)?V08gySw$)U6BSZp;tWIhn3^Ep7w;liV{D+1qDcnN7NPW zx)@dIx$hbuy-)-ht>wRq7Kwd@)Ztf;?D5<>y2TbIm>;3C2zh8E9CNl?Si&}r2AFh9 z-#qJde$Q(jUK0^(>5JPGO^nUBC5&bZZLdj}$IcXaPrFVl({?v;?KG(`wDA>PlL+Sj z1tw5>&*g>)fw#ufN@rVYjMTmRiwGTA^{D#08U8$>!t*g!ZI@n&I6)3YmWf0Ni|AcR zf{94}fi_MHR1gr6t2i%O!i_h2dS0ePwlUExt*qNsobSjHxb?A%+aJhEoE^WCS>#Zp zRa|bvZ=HAT;LwR7S)Kp%l&(&Yoc)S0Vh=y3FqXsAgD`~}6MH@431ud0G1v#SJ+`c^d z=khH;`hB#Q5XHdx*b8HlQi0sdeRpgM_dD(1s=O%fpgN>X+wW!*SQ_t$v|qM&`z@== zsVES2+U)&xQIGp(36Lx*(cu`)UgR%GN8fptbbs#f;P405gTeAa zz2cAdmw%rt$}4X%S&#WtB6y<9(zLL~WU8bO8w+VmPwTtpwG1z%Y0|&Y6`MXbMK@^# zcLv)8pADW1URf4cJMcx}%igt?H9I~%J~=*KzDmCOo$q50w28O5$9{>eN=Z&Rm8`Xk z4mCtLXb8gkv`Lz+e#Tm-wVk~OJt@87*arwpjpxMRksVq!+7|E%_#Q-D@7{;Jlg+(x zYWAZo++H?TOr2peNIs;l`e)bxR{pQDr|#Tqef%{#x;VPKs24Lh za2GyMJ^Y?8sS|=Fdglcg>j&vpp3$3J9v->p{4Vs#XDO*tiyVujp5ma+rPZa~Qz?xz zjTE<8_p78G^{Dz5l5K!{Kx#c~AqIe#U(Do{U z@Ld=&8{vUF5lx==qcVA`xr(Nu0}1d1wS)!T zqFlbd<-v%nbrxj}gn9LOv3!0qKl#GK18~Ypp;0MgpP~5~%NO|u+2i@PX&>zGO4@JF zFIy`czS??xyXCWjPb!8=ErvXo(y~t5n~9VPtRw0)mJo3@4{H)@N_uiH&ADkQLPRxj zCL>8Vn>&yr%%O;O)J+dW&P1kN`jV2i-ild1B_BriY#jMu*|YBhW9g1Zq{}_`0oOv; z8@D`ZSEnAVo#-#WS`q9xTcz$|*xE_%jjW5Q!~2CR*Qy@?LmSn--L29b26C=ce+-*- zO_E4F(xI)@K)CiS{;Bd4od*1TX}P7WMWCXTMWuzR`AhO7sdY7@*D>QHM7t z1g677hq2+=XQTCdl^xZYpzJf5n=Mp+tm*yKOZu1I-L}R!+SDiAu()aA0(Bd4$643a z%`oWZAI(x6Eki23=SrVGZVqa$diVYb%c1Oqqst1Z%5$MN_|94%UvX?ABa5NCE~ACk z{uJK3*3@{k_YdW%ZY2 zxZ@P!WWq16&V6h<92au#Mrtj?XVsm^UsqfrHskg}_ff{6;#}&i%)#A(we?+B%O*m4 z7FJ|gh7MG>H-RGpeyz`kb5wLKJ)hNYZkV}B6uM;!H`-B-X<>+`bU^6AG($2Eca?(@)m?a=YW^$eC{ zOI3cer2pJt_eR>-tj%Nc3$q5fmix`0rybTRr|PLB=BP7Oic$YMf3PKSJ!fT481hTC z`wU=saK=z?(eqxkK6bQv-yz($<*?h+a-T6BF@30|U!IwEDKYkehdfpTH;xXcXP0#x zQvK$({_yokz@5Mi1WZC-^Q+tP2CM4w$!m9>d>fp{Ezq7Ue{qCXd3#*CZ4*v?r8Z0a z)|?d}rqQ@iy`Xw1D{T7nuI2ahWyw|rVLU4_OY8qywRL~4p^)#=@(777 zfBiY)Nry>P{0{&EqVV3{IJTbT2u4=`sRm}o`R(ly$QHL0HomwUTlbn!BWU106ay(aSYj>7%Y}8Q6Zog zo}G${rvjiliA?jtc>^G2vq&s^^Cu86f5Uz0Bp(cgP9$LHGyo*~kV!Z{b~emrWGZKK zcmJEV-rV(nEaHEP>rEv9+R;zZHnlbfWJ`?W7$UnQwmR7C%bzy(cp{FfW=kewND%Nx zX8=x5|E|UZDL8Kk41mKSu%92GrKzc*33vlPF$DX~f%5^RpBP+=t%Ux8>B8C4;-8o< zTcH0p28VMl_D>A??|29}`*q>J?O+Jqe_% select(compression, stringmethod, adj_time, adj_bytes) -> dd6 print(xtable::xtable(dd6 %>% filter(compression=="snappy")%>% full_join(dd6 %>% filter(compression =="none"), by="stringmethod") %>% select(stringmethod, time_uncomp=adj_time.y, bytes_uncom=adj_bytes.y, time_snappy=adj_time.x, bytes_snappy=adj_bytes.x) %>% mutate(ratio=round(bytes_uncom/bytes_snappy, 2), time_uncomp=round(time_uncomp, 2), time_snappy=round(time_snappy, 2), bytes_uncom=round(bytes_uncom/1024/1024, 1)) %>% select(stringmethod, time_uncomp, time_snappy, bytes_uncom, ratio)), include.rownames=FALSE) + + + +sysnames <- c("mariadb-default"="MySQL", "mariadb-compress"="MySQL+C", "postgres-default" = "PostgreSQL", "db2-default" = "DB2", "monetdb-prot10"="MonetDB++", "monetdb-prot10-snappy"="MonetDB++Sy", "netcat-csv"= "netcat") + + +read.table("51.csv", header=T, sep=",", stringsAsFactors=F, na.strings="-1") -> dd3 + +ntuples <- 10000000 + +dd3 %>% filter(system %in% c(names(sysnames)), timeout != 1, tuple %in% c(1,ntuples)) %>% mutate(system=sysnames[system]) %>% select(system, network, tuple, time, bytes) %>% group_by(system, network, tuple) %>% summarise_each(funs(mean,sd,se=sd(.)/sqrt(n()))) -> dd4 + + + dd5 <- as.data.frame(dd4 %>% filter(tuple==ntuples) %>% rename(time_1m=time_mean, bytes_1m=bytes_mean) %>% left_join(dd4 %>% filter(tuple == 1) %>% rename(time_1=time_mean, bytes_1=bytes_mean), by=c("system", "network"))) %>% mutate(tuple_time_ms=((time_1m-time_1)/ntuples)*1000, tuple_bytes=(bytes_1m-bytes_1)/ntuples, adj_time= time_1m-time_1, adj_bytes=bytes_1m-bytes_1) %>% select(system, network, adj_time, adj_bytes) + + + +pdf("10m-final-time-unlimited.pdf", width=10, height=3) + +ggplot(dd5 %>% filter(network=="unlimited", system!="netcat"), aes(y=adj_time, x=reorder(system, -adj_time), label=round(adj_time, 1))) + geom_hline(yintercept=1.634335, linetype="dashed") + geom_bar(stat="identity", position="dodge", width=.5) + theme + xlab("") + ylab("Wall clock time (s)") + coord_flip() + geom_text(size=7, hjust=-.2, family="serif") + scale_y_continuous(limits=c(0, 90)) + +dev.off() + +pdf("10m-final-time-slownet.pdf", width=10, height=3) + +ggplot(dd5 %>% filter(network=="10mbitethhd", system!="netcat"), aes(y=adj_time, x=reorder(system, -adj_time), label=round(adj_time, 1))) + geom_hline(yintercept=1014.811853, linetype="dashed") + geom_bar(stat="identity", position="dodge", width=.5) + theme + xlab("") + ylab("Wall clock time (s)") + coord_flip() + geom_text(size=7, hjust=-.2, family="serif") + scale_y_continuous(limits=c(0, 2000)) + +dev.off() +