Kouhei Sutou
kou****@clear*****
2018年 8月 27日 (月) 17:01:40 JST
$B?\F#$G$9!#(B In <5BEB0****@WMBOX*****> "[groonga-dev,04660] where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B" on Mon, 27 Aug 2018 01:26:35 +0000, $B</3Q(B $B9@;J(B <kazun****@nttco*****> wrote: >>$B$^$:!"(Bpaths == "..."$B$r(Bpaths @ "..."$B$K$7$F$_$F$/$@$5$$!#(B >>$B$3$l$G8!:w7k2L$, ＠ 5$7$/$J$k$3$H$r4|BT$7$F$$$^$9!#(B >>$B!JB.EY$O$=$s$J$KJQ$o$i$J$$$+CY$/$J$k$H;W$$$^$9!#!K(B > > $B!z#1(B > $B8!:w7k2L$O ＠ 5$7$$FbMF$,F@$i$l$?$,!"(BExecution time$B!J<B9T;~4V!K$K$D$$$F$O2~A18z2L$,8+$i$l$:(B > $BCY$$7k2L$H$J$C$?!#(B $B4|BTDL$j$N7k2L$G$9!#(B $B!V%Y%/%?!<$NCM!J(Bpaths$B!K$N$I$3$+$KCM$,4^$^$l$F$$$k$3$H!W$H$$(B $B$&>r7o$K$O!V(B==$B!W$G$O$J$/!V(B@$B!W$r;H$$$^$9!#%$%s%G%C%/%9$r;H$C(B $B$?>l9g$O$?$^$?$^!V(B==$B!W$G$b$&$^$/F0$-$^$9$,!"@5$7$/$O!V(B@$B!W$J(B $B$N$G%$%s%G%C%/%9$r;H$C$F$$$J$$>l9g$G$O$&$^$/F0$$$F$$$^$;$s$G(B $B$7$?!#(B >>$B8!:w7k2L$, ＠ 5$7$/$J$C$?$i!"(Bwork_mem$B$rA}$d$7$F$_$F$/$@$5$$!#(B >>$B$3$l$G8!:wB.EY$b2~A1$9$k$H;W$$$^$9!#(B > > $B!z#2(B > $B!V(Bwork_mem$B!W$r%G%U%)%k%H$N!V(B2MB$B!W$+$i!V(B8MB$B!W$KJQ99$7$?$H$3$m$G!"(B > Execution time$B!J<B9T;~4V!K$,Bg$-$/8:>/$9$k7k2L$,8+$i$l!"(B > $B ＠ -G=$,2~A1$9$k$3$H$,J,$+$C$?!#(B $B$3$A$i$b4|BTDL$j$G$9!#(B > $B%7!<%H!V(BSQL$BHf3S!W$N-"$N(BSQL$B$N$h$&$K!"8!:w>r7o!JItJ,0lCW!K$r(B > $B#22s;XDj$7$?(BSQL$B$r;HMQ$7$?>l9g!"(B > $B2?$+7|G0E ＠ Ey$O$"$j$^$9$G$7$g$&$+!)(B > > " WHERE (order_json_info_pgroonga ->> 'applicationArrivalDate' between" > " '2018/01/01' and '2018/07/02')" > " AND (order_json_info_pgroonga operator(pgroonga.@@)" > " 'paths ==""contractCustomerName""&& string @""$B3t(B""')" > " AND (order_json_info_pgroonga operator(pgroonga.@@)" > " 'paths ==""contractCustomerName""&& string @""$B3t(B""'))" > $B!!!!!!!!(BSELECT a1.sys_no $BITI,MW$J>r7o$r(B2$B2sI>2A$9$k$3$H$K$J$k$N$GITI,MW$K<B9T;~4V$,$+(B $B$+$k$3$H$,7|G0E@$G$9!#(B $B$H$3$m$G!"$3$N(BSQL$B$G$O(B WHERE (order_json_info_pgroonga ->> 'applicationArrivalDate' between '2018/01/01' and '2018/07/02') $B$,%\%H%k%M%C%/$J$s$G$9$,!"<0%$%s%G%C%/%9$G(B CREATE INDEX index_name ON flex_order_ref_pgroonga (to_date(order_json_info_pgroonga->>'applicationArrivalDate', 'YYYY/MM/DD')); $B$_$?$$$K(Bdate$B$K$7$F$7$^$C$F(B WHERE (to_date(order_json_info_pgroonga->>'applicationArrivalDate', 'YYYY/MM/DD') between to_date('2018/01/01', 'YYYY/MM/DD') and to_date('2018/07/02', 'YYYY/MM/DD')) $B$_$?$$$K$9$l$P%$%s%G%C%/%9$r;H$C$FB.$/7W;;$G$-$k$s$8$c$J$$$+(B $B$J$!$H;W$$$^$7$?!#!J;n$7$F$$$^$;$s!#!K(B -- $B?\F#(B $B8yJ?(B <kou****@clear*****> $B3t<02q<R%/%j%"%3!<%I(B <http://www.clear-code.com/> Groonga$B%Y!<%9$NA4J88!:w%7%9%F%`$rAm9g%5%]!<%H!'(B http://groonga.org/ja/support/ $B%G!<%?=hM}%D!<%k$N3+H/!'(B http://www.clear-code.com/blog/2018/7/11.html
