鹿角 浩司
kazun****@nttco*****
2018年 8月 31日 (金) 16:32:44 JST
$B?\F#MM(B $B</3Q$G$9!#(B $B$*@$OC$K$J$j$^$9!#(B $BJV?.$,CY$/$J$C$?;v$r$*OM$S$7$^$9!#(B $B%3%a%s%H$"$j$,$H$&$4$6$$$^$7$?!#(B $B65$($FD:$$$?FbMF$G8!F$CW$7$^$9!#(B $B$4BP1~$"$j$,$H$&$4$6$$$^$7$?!#(B -----Original Message----- From: groon****@lists***** [mailto:groon****@lists*****] On Behalf Of groon****@lists***** Sent: Tuesday, August 28, 2018 12:00 PM To: groon****@lists***** Subject: groonga-dev $B$^$H$aFI$_(B, 114 $B4,(B, 8 $B9f(B groonga-dev $B%a!<%j%s%0%j%9%H$X$NEj9F$O0J2<$N%"%I%l%9$KAw$C$F$/$@$5$$!%(B groon****@lists***** Web$B%V%i%&%6$r;H$C$FF~B`2q$9$k$K$O0J2<$N(BURL$B$K$I$&$>!%(B https://lists.osdn.me/mailman/listinfo/groonga-dev $B%a!<%k$r;H$&>l9g!$7oL>(B(Subject:)$B$^$?$OK\J8$K(B help $B$H=q$$$F0J2<$N(B $B%"%I%l%9$KAw?.$7$F$/$@$5$$!%(B groon****@lists***** $B%a!<%j%s%0%j%9%H$N4IM}<T$X$NO"Mm$O!$0J2<$N%"%I%l%9$K$*4j$$$7$^$9(B. groon****@lists***** $BJV?.$9$k>l9g!$7oL>$r=q$-D>$7$FFbMF$,$o$+$k$h$&$K$7$F$/$@$5$$!%(B $B$=$N$^$^$@$H!$0J2<$N$h$&$K$J$C$F$7$^$$$^$9!%(B "Re: groonga-dev $B$^$H$aFI$_(B, XX $B4,(B XX $B9f(B" $BK\F|$NOCBj(B: 1. [groonga-dev,04661] Re: where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B (Kouhei Sutou) ---------------------------------------------------------------------- Message: 1 Date: Mon, 27 Aug 2018 17:01:40 +0900 (JST) From: Kouhei Sutou <kou****@clear*****> Subject: [groonga-dev,04661] Re: where$B$GF1$8>r7o$r(B2$BEY;XDj$7$J$$$H ＠ 5$7$$7k2L$,JV$i$J$$7o$K$D$$$F(B To: groon****@lists***** Message-ID: <20180****@clear*****> Content-Type: Text/Plain; charset=iso-2022-jp $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 ------------------------------ _______________________________________________ groonga-dev mailing list groon****@lists***** https://lists.osdn.me/mailman/listinfo/groonga-dev $B0J>e(B: groonga-dev $B$^$H$aFI$_(B, 114 $B4,(B, 8 $B9f(B ******************************************
